Difference between revisions of "Why do my Debtors/Creditors not Agree to my Balance Sheet?"
Tim Laundon (talk | contribs) |
Tim Laundon (talk | contribs) |
||
Line 1: | Line 1: | ||
{{Incomplete}} | {{Incomplete}} | ||
== Summary == | == Summary == | ||
− | The following article sets out to explain reasons why, and checks that can be made, if, at month end | + | 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 == | == 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/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 == | ||
− | The following | + | The following checks should be done to see why the ledger balances might not agree to the balance sheet Control Accounts. |
− | * Go to 'Sales Ledger' -> 'Sales Reports' -> 'Daybook Summary' and enter in | + | * 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, doing 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, deduct it from the balance on the balance sheet. | * Under no circumstances should any manual postings be done to Z994, doing 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, deduct it from the balance on the balance sheet. | ||
* Re-Run the Nominal Update for the month you are trying to close as there may be some items stuck in the sales ledger that need processing, and re-check the Aged Debtors and compare to Z994. | * Re-Run the Nominal Update for the month you are trying to close as there may be some items stuck in the sales ledger that need processing, and re-check the Aged Debtors and compare to Z994. | ||
− | |||
− |
Revision as of 16:37, 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 Z993/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, doing 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, deduct it from the balance on the balance sheet.
- Re-Run the Nominal Update for the month you are trying to close as there may be some items stuck in the sales ledger that need processing, and re-check the Aged Debtors and compare to Z994.