Skip to content
logo Knowledgebase

Understanding and posting to system accounts.

Created on  | Last modified on 

Summary

Understanding and posting to system accounts in Sage Accounting.

Description

System Accounts are specific accounts that you use in Sage Accounting to record transactions relating to specific documents or transactions.

Example: All Items sold will go to the Sales system account. 

Resolution

These accounts are calculated at points in time based on the transactions that have occurred in the date range specified. These are not like normal accounts and cannot be posted to via journal entries. 

 

Below we will explain how each of the Sage Accounting system account work and how you go about affecting them. 

 

Opening Balance and VAT Adjustments 

 

This account is used when you capture an opening balance transaction or a VAT adjustment.  

 

The Opening Balance and VAT Adjustment System account will be affected with the following contra accounts: 

 

Transaction 

Contra Effect  

Account Opening Balance 

Normal Account 

Customer Opening Balance 

Individual Customer (Trade Receivables System Account) 

Supplier Opening Balance 

Individual Supplier (Trade Payables System Account) 

Bank Opening Balance 

Bank Account 

VAT adjustment  

VAT Payable System Account 

 

Retained Income 

 

This is a calculated system account, which is the sum of all profits and losses up to the beginning of the financial year.  

 

The only way to affect this account is to post an entry to a profit and loss account in a previous year – you can achieve this with opening balance entries in prior years as well. 

 

Trade Payables and Trade Receivables 

 

These system accounts work in the same way, one for Customers and one for Suppliers. They record all transactions related to individual customers and suppliers: 

 

The following documents have the below effects on Trade Receivables / Payables: 

 

Document 

Effect on Receivables / Payables 

Contra Accounts Affected 

Invoice 

Increase 

Item / Account 

Credit Note / Return 

Decrease 

Item / Account 

Adjustment 

Increase / Decrease 

Account 

Receipts / Payments 

Decrease 

Bank 

Opening Balance 

Increase 

Opening Balance & VAT Adjustments 

 

  • NOTE – all these documents can have a VAT effect as well, if desired. 

 

Sales and Purchases (*including Sales and Purchases sub-accounts) 

 

These system accounts work in the same way, one for Customers and one for Suppliers. They record all Item Sales or Item Purchases, in other words each time you buy or sell an inventory item one of these two system accounts are affected: 

 

The following documents have the below effects on Sales / Purchases: 

 

Document 

Effect on Sales / Purchases 

Contra Accounts Affected 

Invoice 

Increase 

Trade Receivables / Trade Payables 

Credit Note / Return 

Decrease 

Trade Receivables / Trade Payables 

 

VAT Payable 

 

There are numerous ways of affecting the VAT system account. All normal transactions with a VAT type used will result in an entry to the VAT system account 

 

VAT Adjustments 

 

There are various VAT adjustments that are available that can affect different areas of the application: 

 

Transaction 

Contra Account Affected 

VAT Adjustment 

Opening Balance & VAT Adjustment Account 

Journal Entry (using 100% VAT Adjustment VAT Type) 

Normal Account 

Customer Adjustment (using 100% VAT Adjustment VAT Type) 

Individual Customer (Trade Receivables System Account) 

Supplier Adjustment (using 100% VAT Adjustment VAT Type) 

Individual Supplier (Trade Payables System Account) 

Banking entry (using 100% VAT Adjustment VAT Type) 

Bank Account