Hi EE RR ,

Thank you for reaching out regarding the discrepancy between your Accounts Receivable (AR) account and the total of your customers' outstanding invoices. Below are some steps pulled from this article on How to post to a linked account properly.

Resolving the AR Discrepancy:

1. Posting to Linked Accounts: Sage 50 CA relies on linked accounts for transaction processing. If you post an adjusting entry to an unlinked account, you'll create a discrepancy between the account balance and the sub-ledger once you link the account. It’s important to avoid posting directly to linked accounts like AR in the general journal.

2. Consult Your Accountant: Your accountant, especially if they have access to the Accountants Edition of Sage, can assist with posting to linked accounts without causing data inconsistencies.

3. Workaround Options:

   • Adjusting AR Balance: If there are discrepancies in the AR balance, you can use the Customer Aged report to check unpaid invoices. If there are invoices that are either unpaid or missing, you can address these through the receipt or sales journal as appropriate.
   • Other Workarounds: There are additional options for adjusting account balances, such as for A/P, prepayment, deposit, and vacation payable accounts. These are detailed in the Sage knowledge base.
     
     

4. Posting to a New Account: If necessary, create a new account number (e.g., instead of posting to inventory linked asset account 1540, create account 1541) and post to that account to avoid affecting the linked account directly.

Next Steps:

• Backup Your Data: Always back up your data before attempting any advanced solutions.
• Consulting a Professional: If you're unsure or need assistance, it's advisable to seek help from a qualified Sage business partner or Sage Expert Services.

Hope this helps! If you need further assistance or have more questions, please don't hesitate to connect with us through the Help and Chat options available within your Sage product.

Warm Regards,
Erzsi