GL: Must the Ledger Home DR tally with Home CR and Home Balance = 0.00

From AutoCount Resource Center

Question: Must a Ledger supposedly tally for Home Debit and Home Credit, and Home Balance is 0.00?

Version: 1.8 / 1.9 / 2.0

Ledger dr=cr.png

Answer :

Yes, ledger must be tally for both Home DR and Home CR, and Home Balance must be 0.00.
If not, your account is considered not balanced.

Please do some checking if it is not tally.
1) Make sure Ledger filter options set correctly.
- Ledger Type select All Ledger
- Do not enable show Debtor/Creditor Control Account Only
- Do not filter on Account, Control Account and Project/Department.
- Do not enable Add Profit/(Loss) to Retained Earning

Ledger dr=cr1.png

Ledger dr=cr8.png

2) Make sure Opening Balance or YTD Balance Maintenance is balanced.

Ledger dr=cr2.png

3) Retained Earning must be Special Account (with blue color) and Special Account Type is SRE.

Ledger dr=cr3.png

4) Make sure amount key in at Stock Value Maintenance tally with Opening Balance Stock account balance.

Ledger dr=cr4.png

Ledger dr=cr5.png

5) Make sure there is no parent account being used/selected in any document.
Go to AutoCount Management Studio > Tools > SQL Query, use the following SQL query to check:

Select * from GLDTL where AccNo in (Select ParentAccNo from GLMAST)

Ledger dr=cr6.png

Ledger dr=cr7.png

By: Aimi 220513, Lay Swan 220524, P220525

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations