Difference between revisions of "Why do my Debtors/Creditors not Agree to my Balance Sheet?"
From Catalyst
(New page: {{Stub}}) |
Tim Laundon (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | {{ | + | {{Incomplete}} |
| + | == 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 == | ||
| + | As standard, 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 a [[How do I View the Outstanding Balance on a Nominal Centre?|value of the relevant purchase or sales centre]], the 2 values should agree. If not, the following article will give you pointers to check. | ||
| + | |||
| + | == In Detail == | ||
| + | The following example will run through checking reasons why the debtors don't agree to the balance sheet. The process for the creditors is exactly the same. | ||
| + | |||
| + | * Go to 'Sales Ledger' -> 'Sales Reports' -> 'Daybook Summary' and enter in tomorrows date. There should be no forward postings shown. If there are, subtract that total amount from the value on the balance sheet and see if the figures now balance. | ||
| + | |||
| + | * 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. | ||
| + | |||
| + | * With just yourself in Platinum, go to 'Sales Ledger' -> 'Customer File Maintenance' -> 'View Customers'. The value in the 'Total Balance' should equal the current Aged Debt List. If it does not, please contact Catalyst on 0116 2301500 and ask for Support. | ||
Revision as of 15:58, 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
As standard, 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 a value of the relevant purchase or sales centre, the 2 values should agree. If not, the following article will give you pointers to check.
In Detail
The following example will run through checking reasons why the debtors don't agree to the balance sheet. The process for the creditors is exactly the same.
- Go to 'Sales Ledger' -> 'Sales Reports' -> 'Daybook Summary' and enter in tomorrows date. There should be no forward postings shown. If there are, subtract that total amount from the value on the balance sheet and see if the figures now balance.
- 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.
- With just yourself in Platinum, go to 'Sales Ledger' -> 'Customer File Maintenance' -> 'View Customers'. The value in the 'Total Balance' should equal the current Aged Debt List. If it does not, please contact Catalyst on 0116 2301500 and ask for Support.
