Billing Assistant balance and Accounts Receivable balance are inconsistent

Sage Timeslips can show incorrect balances when payments remain unapplied in suspense. You can correct these issues using the Billing Troubleshooter and rebuild client Accounts Receivable (AR) balances.

Correct unapplied payments in suspense

Unapplied payments often cause these symptoms:

• Billing Assistant shows an incorrect balance.
• Billing Assistant balance doesn’t match the A/R balance.
• Aged Receivables Report shows unapplied payments.

Use the Billing Troubleshooter to correct suspense items.

1. Select Bills, Troubleshooter....
2. Choose A/R Transactions with suspense.
3. Review the listed clients with suspense items.
4. Select Open Transaction ### to apply for each listed client.

This process applies the suspense payments and corrects the balances.

Rebuild the AR balance for a client

Use this process if suspense correction doesn’t resolve the issue.

1. Create a backup of the database.
2. Undo the last bill for the affected client if it’s incorrect.
3. Delete any unbilled AR transactions for that client.
4. Record details of deleted transactions for later re-entry.
5. Unapply all payments and save them with Apply to future invoices selected.
6. Select File, Data Verification.
7. Mark Check Accounts Receivable Balances.
8. Mark Select Client, then choose the affected client.
9. Select Automatically repair any errors found.
10. Click OK.
11. Click Yes to start rebuilding balances.
12. Click No when prompted to make another backup.
13. Click Close after the process completes.
14. Reapply the payments unapplied earlier.
15. Re-enter the A/R transactions deleted previously.

This process rebuilds the client’s AR balance and restores accurate billing data.