21- Financial Statements

Sub ledger and Control Account

I am trying to change my year from 2016 to 2017 but it is saying,
The sum of your Customers’ information does not equal the current balance of account 1200 Accounts Receivable.

$0.00 Total Outstanding Invoices
$17,546.99 Current Balance of 1200 Accounts Receivable
_______________
-$17,546.99 Difference

Either your Customers’ historical information or the opening balance of account 1200 Accounts Receivable, or both, is incorrect.

If your trying to fix it by doing a journal entry and can not access account 1200 that is a good thing.

It means that account 1200 Accounts Receivable is linked.

go to Setup – Settings – Receivables – linked Accounts

settings AR

 

 

 

 

 

 

Leave that screen and lets check the control account against the sub ledger.

The control account is account 1200. in this account all the customer invoices and all the customer payments are recorded as debit and or credit. the net balance at any given time should equal with the sub ledger and that is where you post your invoices or in receipts where you post your payments.

You can always view the control account by pulling up a balance sheet.

Drop down Reports – Financials – Balance Sheet

Choose your date. Mine is March 31, 2015.

Balance sheet for AR

 

 

 

 

 

 

 

The amount in AR is 341,844.34 and this amount has to equal with the AR listing.

Frist click on Reports – Customer & Sales – Customer Aged.

Report Type should be Summary – Select All – and the date should be same date as the Balance sheet.

Mine is March 31, 2015.

Customer Aged

 

 

 

 

 

 

2nd screen to get to the report.

Customer Aged Report

 

 

 

 

 

click on ok and view the report and the balance to match.

Customer Aged Report 2

 

 

 

 

 

 

 

Notice the sub ledger has the same $34,844.34 balance as the control account on balance sheet.

 

So, when your trying to advance from one fiscal year to another ex: from 2016 to 2017 business year all these account have to be aligned.

sometime during the year the control account 1200 was affected outside of the sub ledger AR and Receipt journal. a picture of it is below.

Home Screen

 

 

 

 

 

 

This Classic View but you might be working in the Enhanced View.

Go through the account 1200 and see where the system was changed.

Hope this tutorial helped.

come back and visit the site for more.

Be the first to comment - What do you think?

WHAT ARE CONTROL ACCOUNTS?

What are control accounts?

In Sage 50 and accounting world for that matter there are two control accounts, they are called Accounts Payable and Accounts Receivable.

Now why are they called control accounts? The reason is they control all Payalbe and receivable transactons, invoices, credit notes and payments posted in the Sub ledges.

Now you will ask what a sub ledger is. these are the ledgers you use to enter sales journal, purchase journal, payment journal and receipt journal.

Everything you post in the sub ledgers will automatically be posted to the control account as a debit or credit depending on what type of entry it is.

A control account, ex: account# 1200 Accounts Receivable, cannot be accessed and a standalone entry cannot be posted to it. It is a linked account and cannot be accessed on its own in an entry.

A Control account, ex: accounts# 2100 Accounts Payable, cannot be accessed and a standalone entry cannot be posted to it. It is also a linked account and cannot be accessed on its own in an entry.

 

Be the first to comment - What do you think?

« Previous PageNext Page »