Difference between revisions of "Why do my Debtors/Creditors not Agree to my Balance Sheet?"
From Catalyst
Tim Laundon (talk | contribs) |
Tim Laundon (talk | contribs) |
||
| Line 4: | Line 4: | ||
== More Information == | == More Information == | ||
| − | Z993 and Z994 on the Balance Sheet are the control centres for the purchase and sales ledger. If you run an [[How do I print an Aged Debtor or Creditor List?|Aged Debt List]] and then compare that figure to | + | Z993 and Z994 on the Balance Sheet are the control centres for the purchase and sales ledger. If you run an [[How do I print an Aged Debtor or Creditor List?|Aged Debt List]] and then compare that figure to Z994 via Nominal Centre Preview, the two values should agree. If not, the following article will give you pointers to check. |
== In Detail == | == In Detail == | ||
| Line 13: | Line 13: | ||
* Go to 'Sales Ledger' -> 'Sales Reports' -> 'Daybook Summary' and enter in tomorrow's date. There should be no forward postings shown. If there are, add or subtract that total amount from the 'Total Balance' figure obtained in the previous step. | * Go to 'Sales Ledger' -> 'Sales Reports' -> 'Daybook Summary' and enter in tomorrow's date. There should be no forward postings shown. If there are, add or subtract that total amount from the 'Total Balance' figure obtained in the previous step. | ||
| − | * Under no circumstances should any manual postings be done to Z994, | + | * Under no circumstances should any manual postings be done to Z994, since this will most definitely cause a mismatch between aged debtors and the balance sheet. To check for manual postings, go to 'Sales Ledger' -> 'Sales Reports' -> 'Accounts Report Generator' and search for a report entitled 'Manual Postings to Z993/Z994'. If you do not have this report, please contact Catalyst on 0116 2301500 and ask for Support. Once you have found this report, run it. Any total you have on this report, add or subtract it from the balance on the balance sheet. |
| − | |||
| − | |||
Revision as of 16:41, 3 February 2010
 |
This article or section is under development. Be aware: Content will change as the document progresses. |
Summary
The following article sets out to explain reasons why, and checks that can be made, if, at month end your Aged Debtors or Creditors do not match your Balance Sheet for Sales and Purchase Control centres accordingly.
More Information
Z993 and Z994 on the Balance Sheet are the control centres for the purchase and sales ledger. If you run an Aged Debt List and then compare that figure to Z994 via Nominal Centre Preview, the two values should agree. If not, the following article will give you pointers to check.
In Detail
The following checks should be done to see why the ledger balances might not agree to the balance sheet Control Accounts.
- With just yourself in Platinum, go to 'Sales Ledger' -> 'Customer File Maintenance' -> 'View Customers'. The value in the 'Total Balance' should equal the figure shown in Nominal Centre Preview for Z994.
- Go to 'Sales Ledger' -> 'Sales Reports' -> 'Daybook Summary' and enter in tomorrow's date. There should be no forward postings shown. If there are, add or subtract that total amount from the 'Total Balance' figure obtained in the previous step.
- Under no circumstances should any manual postings be done to Z994, since this will most definitely cause a mismatch between aged debtors and the balance sheet. To check for manual postings, go to 'Sales Ledger' -> 'Sales Reports' -> 'Accounts Report Generator' and search for a report entitled 'Manual Postings to Z993/Z994'. If you do not have this report, please contact Catalyst on 0116 2301500 and ask for Support. Once you have found this report, run it. Any total you have on this report, add or subtract it from the balance on the balance sheet.
