Summary
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 |