Opening Balances for New program setup SAGE 50 2015

SUGGESTED

Hello,

I'm converting from an old simply accounting version 2010 to Sage 50 2015. I have already started my year 1/1/2015 and have inputted new invoices and purchases throughout the year.

Now I've gotten to the stage where I need to finish the year and move to 2016. Some time ago, when I first started using the software, I searched about opening balances, and found out that I have to input them through 'historical transactions'. For instance, if i owed "Company A" $300.00 from 2014, I went into the 'Vendor Record" and into the 'Historical Transactions' tab and entered in the opening balance there under 'Invoices'. So I did this for all the payables and receivables, as well as inventory.

Upon finishing the year 2015 (1/1/2016), i wanted to move the software to a future year, while still finalizing 2015. After attempting so, I get an error blocking me from converting to the new year about my customer information and receivables/payables not matching.

Error:
The sum of your Customers' information does not equal the current balance of account 1200 Accounts
Receivable.
$17,958.38 Total Outstanding Invoices
$20,370.93 Current Balance of 1200 Accounts Receivable
_______________
-$2,412.55 Difference
Either your Customers' historical information or the opening balance of account 1200 Accounts Receivable, or
both, is incorrect.


I reversed all the entries that i put into 'Historical Transactions' and now that error is gone. The problem now is that I don't have proper opening balances.

Am I doing something Wrong? How do I make opening balances?

I have not changed my session date to 2016 yet, i'm still working on the 2015 file. i want to make sure my opening balances are correct before I carry on.

Would appreciate your help and feedback

Parents
  • 0
    SUGGESTED

    $17,958.38 Total Outstanding Invoices

    $20,370.93 Current Balance of 1200 Accounts Receivable

    Basically you need to tell Sage 50 which one of the amounts is true:

    1. You're missing 2,412.55 worth of Sales Invoices - Enter the Historical Invoices so that you get the invoice module to match the A/R balance of 20370.93
    2. Or, I had no opening A/R balance when I first started this company file and 17958.38 is correct - Decrease the amount of the opening balance by 2412.55 in the A/R record opening balances in the Chart of Accounts.
Reply
  • 0
    SUGGESTED

    $17,958.38 Total Outstanding Invoices

    $20,370.93 Current Balance of 1200 Accounts Receivable

    Basically you need to tell Sage 50 which one of the amounts is true:

    1. You're missing 2,412.55 worth of Sales Invoices - Enter the Historical Invoices so that you get the invoice module to match the A/R balance of 20370.93
    2. Or, I had no opening A/R balance when I first started this company file and 17958.38 is correct - Decrease the amount of the opening balance by 2412.55 in the A/R record opening balances in the Chart of Accounts.
Children
No Data