Logo
  • Features
  • Pricing
  • Support
  • Contact
  • Blog
  • E-Invoicing
  • About
  • Integration
  • API
  • About Integration API
  • Login
    Accounting
    Point Of Sales (POS) Job Order
Warning! Payment is due for the implementation of this System. Please refer to the Product Detail page.
Warning!

How to pinpoint which transaction caused an unbalanced Trial Report and Balance Sheet?

Posted By  casey  at  May 07 2021 11:48        1244


Balance Sheet

Balance sheet is separated into 2 sides. On one side are assets and the other are liabilities and owner's equity. Balance Sheet got it's name because both sides of the accounts should always be equal. The main reason to the "balanced" accounts is the accounting principle of double entry. This means it records all transactions in at least two different accounts, and therefore also allow users to check if the entries are consistent. Each side, on its own, should add up to the total value in the business. The formula to a balance sheet is:

Assets = Liabilities + Owner's Equity

Both sides must always be balance because the total value of the business's Assets are all funded through Liabilities and Equity. When you enter your transaction in TreezSoft, our accounting system will automatically generate the double entries for you. TreezSoft allows you to generate a balance sheet report in a few clicks.

If your balance sheet is not balanced, it means there's an error in your account entries. Error scanning and identification can easily be done in TreezSoft balance sheet system. In this blog, we will guide you on how you can do it.

Identify the problem

To find out what caused the error, you will first need to narrow down the report period by searching month-by-month.

Go to General Ledger > Trial Balance / Balance Sheet

Below is the Trial Balance screen:

  1. Go through month-by-month on the date searching bar.
  2. Click "Retrieve" to get the transaction of that month.
  3. Look at the total amount at the bottom right screen to check.

Once identified the month where unbalanced transaction started, go to Journal Report and generate a report for that month.

Navigate through General Ledger > Journal Report.

Journal Report will generate all the transactions for the month and you will be able to pinpoint which transaction caused the unbalanced figure.

  1. Select the date where unbalanced transaction started.
  2. Click "Retrieve" to generate all the transaction for that month.
  3. Identify the unbalanced transaction. 

Once you've found out the particular transaciton, you can make respective adjustment to your business transactions recordings.

**Note: Repeat these steps if you have multiple unbalanced records until balance sheet is balanced.

 

You can also visit the links below to read more on related topics in TreezSoft:

  • Common mistakes in bookkeeping

  • Why my balance sheet and ageing summary reports are not balanced?

  • Financial Reports in Treezsoft

  • How to customize or group my accounts in financial reports.

  • How to view journal report in Treezsoft?

TreezSoft is a cloud accounting software for Small and Medium-sized Enterprises (SMEs). It allows you to access your financial information anytime, anywhere. It also allows you to have unlimited users for FREE for your account in TreezSoft. Our aim is to help reduce our clients' time spent on accounting mainly by using our automated processes and integration to help increase their company efficiency at a minimum cost. SMEs can use TreezSoft to keep track their expenses, accounts, daily operation e.g. Point of Sales (namely QPOS) system and etc. 

Visit TreezSoft at http://www.treezsoft.com/ to sign up for a 30 days trial account with us! 

You can also email us at [email protected] for more enquiries.

 


Keyword balance sheet transaction trial balance journal report unbalanced transaction general ledger listing

Recent

Simple Steps to Create Consolidated eInvoices How to Assign eInvoice Classification Code Invoicing for Optical Business Understand the Types of e-Invoice in Malaysia Registering as a Business Owner for Sole Proprietors in MyTax for E-Invoice Submission

Related

4 Proven Steps to Maintain A Healthy Balance Sheet How to record Barter trades (stock exchange) in transaction? What are the things I need to consider for back date transactions? How to show dividend declared in balance sheet? Financial Reports in Treezsoft Why my balance sheet and ageing summary reports are not balanced? What is an Off-Balance-Sheet? How to record credit card transaction charges deducted by banks? (on accounting system itself) The magic in managing your financial health How to record credit card transaction charges deducted by banks? (on POS sales) How to view journal report in Treezsoft? 4 Telltale Signs of A Healthy Balance Sheet
About About
  • About Us

Product Product
  • E-Invoicing
  • Features
  • Price

Resource Resource
  • Support
  • Blog
  • API
  • FAQ

Subscribe Us Subscribe Us
  • Sign Up
  • Contact Us

  
 [email protected]
 +6012-787 5077
  • playstore
Logo
© Copyright - TreezSoft.com. All rights reserved.
Hours: Mon-Fri 9am-5pm Term of use    |    Privacy      |    Site Map

Alert Message

0%

Confirm Message