Retained Earnings and System Income Clearing

Retained Earnings and System Income Clearing

This help file explains how COSTAR handles Retained Earnings and what happens during an end of year update. Within this document any reference to a year is the financial year.

COSTAR calculates the Retained Earnings each time a financial batch containing either an expense or revenue General Ledger (GL) is posted. This means that the system is reporting on accurate figures and a user doesn’t have to wait until an end of year update to see accurate Retained Earnings figures.

Because COSTAR is a double entry system for every debit entry there is a credit entry. Given that Retained Earnings is updated every time a batch containing an expense or revenue is posted, there needs to be another entry to maintain a balanced trial balance. The other entry goes to a GL called System Income Clearing to balance the value going to the Retained Earnings. The entries to Retained Earnings and System Income Clearing are generated by the system.

 

E.g. A journal is processed as follows and then posted.

DB Computer Expense (E) $250

CR Rebate (R) -$100

CR Bank Account (A) -$150 [Revenue (-100) + Expense (250) = 150]

 

Costar will generate a system journal in the same batch as follows;

 

DB Retained Earnings $150

CR System Income Clearing -$150

This means that at all times the net total of all revenue and expenses for the current year will equal the Retained Earnings balance and the negative balance of the System Income Clearing for the current year.

 

The Retained Earnings This Year on the Balance Sheet should be equal to the Profit(Loss) on the Income Statement. The Retained Earnings This Year figure should also be the negative of the System Income Clearing balance.

 

End of Year

As Retained Earning is updated with each expense or revenue entry, at the end of a year when COSTAR clears all revenue and expense values, the other side goes to the System Income Clearing GL, not Retained Earnings as it has been already updated.

The simple trial balance below illustrates the changes to a trial balance after a year end has been processed. Revenue and Expense lines are cleared to System Income Clearing and Asset and Liability balances become the opening balance of the new year.

 

General Ledger Account        
Bal @ last day of financial year
Bal @ first day of new financial year
Sales Inventory (R)
-15000
0
Sales Services (R)

-5000

0
COS Inventory (E)
11000
0
Salary (E)
3000
0
System Income Clearing (E)
6000
0
Inventory (A)
10000
10000
Bank (A)
2000
2000
Accounts Receivable (A)
50000
50000
Accounts Payable (L)
-56000
-56000
Retained Earnings (L)
-6000
-6000

 

 

Changing the Retained Earnings

The Retained Earnings GL should only be manually changed if the other side of the journal is going to an asset or liability account, and only if it is for a previous year. If processed otherwise the Income Statement and Balance Sheet will no longer balance.

If the Retained Earnings for the current year needs to be changed, it means that either something has not been processed or it has been processed incorrectly. The change needs to be accounted for by processing a journal with at least one expense/revenue GL included. The other side of the journal will be to an asset/liability account. The Retained Earnings GL does not need to be touched manually as the system generated journal will affect the Retained Earnings GL automatically. 

Changing System Income Clearing

The System Income Clearing account should never be touched manually. The only transactions that should affect this account should be system generated.

Posting Back into Previous Financial Years

When posting batches back into previous years the following behaviour occurs;

Revenue & Expense GLs: The change flows through each periods opening and closing balance until the end of the year the batch was posted to

Liability & Asset GLs: The change flows through each periods opening and closing balance until the end of the current year


If you have any queries regarding Retained Earnings and System Income Clearing in COSTAR, please contact the Support Desk
    • Related Articles

    • GST in COSTAR

      GST in COSTAR - Australia This help file outlines how GST works in Costar. It will cover  The setup in the system for GST, Running the GST reports for filling out the GST Calculation Worksheet/Business Activity Statement (BAS) Processing the payment ...
    • General Ledger Entries and Batch Types

      This document looks at the different types of batches in Costar and how they update the General Ledger.  Batch Types in Costar OW – Order Writer Batch RC – Accrued Batch JE – Journal Entry CH – Cheque Run MC – Manual Cheque TC – Tax Clearing Journal ...
    • COSTAR V5 Hardware Requirements

      Below is a link to the hardware recommendations for the COSTAR application. For larger networks or multi-location businesses it is highly recommended that you consult a qualified IT professional for their evaluation of your infrastructure ...
    • Imported Invoices

      COSTAR has the ability to receive fleet and general expense invoices and credit notes (not stock invoices) from a participating supplier that also uses COSTAR. Once set up, when the supplier processes an invoice or credit note in their system it will ...
    • Sales to Finance Companies

      This help file outlines how to process sales to customers that are paying via a finance company. It applies whether the total of the invoice is going to the finance company or the customer may be paying for part of it. Setting up the Finance Company ...