AP error message when trying to start new fiscal year

Hi All;

I have a client that recently started using Sage 50 Pro.  When he created the company file, he input the Trial Balance values from the year end that he got from the accountant.  This included an amount in A/P.  Now he is trying to start his new fiscal year and is getting an error message that the AP is not in balance.  This is probably because the amount was only entered as the original entry and he cannot post directly to AP.  Has anybody had this issue before?  How did you resolve the balance issue? 

Thank you for all your help.

Candice

  • 0
    Hi Candice, I assume you client still in history mode since they just created this company. You need double check "Maintenance's Data integrity screen", if it is not balance there, you cant Start a new year and exit history mode.

    Left hand side is General Leger value, right and side is Sub ledger value. You can update left hand side by General journal, increase opening balance of the account or change a link account.
    Right hand side you can update by go to ledger records and put in historical invoice/balance.

    hope this helps
  • 0 in reply to Jason.
    Problem: Your A/P control account does not match your individual A/P balances, because of the opening balance entered by J/E from the trial balance.

    Solution: Make your A/P control account equal your individual A/P balances.

    There are three different methods for implementing the solution. Which method is best for you will depend on your circumstances.

    Method A: (for use for any A/P item or items set up from the trial balance that are still outstanding and you that want to be able to pay them through your A/P module the same way you are paying invoices that arrived after the change to Sage) (Method A only works if you are still in History mode):
    A1. As suggested above, enter these items as historical invoices. A historical invoice is added to your individual A/P balances without affecting any of your G/L accounts.

    Method B: (for use for any A/P item or items set up from the trial balance that are still outstanding and you that want to be able to pay them through your A/P module the same way you are paying invoices that arrived after the change to Sage) (Method B works even if you have left History mode):
    B1. Temporarily remove these A/P items from the A/P control account by way of a general journal entry. Debit A/P, credit any other account. This is a temporary entry, so the choice of other account is up to you - any account where a couple of oddball in-and-out entries won't bother you later.
    B2. Put these A/P items back into the A/P system by entering them as invoices in the A/P system, with the 'expense' lines on the invoices using the account you creditted in your journal entry in B1.

    Method C: (for use for any A/P item or items set up from the trial balance that are no longer outstanding - and the payments for them have been recorded outside the A/P system. Also for use on any A/P item or items that were included in A/P by the accountant but aren't ordinary A/P you will pay in the ordinary manner - such as accrued interest payable and other yearend-only items).
    C1. Since you want to deal with these A/P items in a different manner than your ordinary trade A/P, you want to segregate them in your general ledger as well. Create a 2nd A/P account (I like to call it 'manual A/P), move all of these items to them by a general journal entry.
  • 0 in reply to C White
    Thank you both for your responses. This sounds exactly like what is happening. I will see if my client has a record of the invoice amounts to enter for balancing. He had only entered the trial balance when he opened his company file so it would make sense that the "invoices" would need to be entered also. I appreciate the details on the different solutions.