Accountants Area (User Manual – Sage Business Cloud Accounting)

Table of Contents

Accountants Area. 3

VAT Transactions. 4

VAT Returns and Reports. 4

VAT Adjustments. 8

VAT Payments and Refunds. 9

The Different VAT Types. 11

VAT Reports. 14

Process Journal Entries. 18

Trial Balance Export 21

Accountant Reports. 25

Financial Statements. 29

Profit and Loss Report 29

Balance Sheet 34

How does Accounting Calculate Financial Balances?. 37

Accountants Area

This area is exclusively for accountant processing such as Journal entries and VAT Adjustments.

If you are not sure about how to process these transactions, we recommend that you seek the advice of a financial professional before proceeding. You can invite your Accountant by selecting the Invite My Accountant option.

You can access these functions by selecting the Accountant’s Area menu option.

The following options available:

  • Send a Note to My Accountant
  • Process Journal Entries
  • VAT
  • Trial Balance Export

VAT Transactions

The VAT section is split into three categories:

  • VAT Returns and Reports
  • VAT Adjustments
  • VAT Payments and Refunds

VAT Returns and Reports

In Accounting you are required to manage your VAT Returns using the VAT Returns and Reports screen.

To access the VAT Returns and Reports screen, click on the Accountant’s Area…VAT…VAT Returns and Reports menu option.

Click on the Next button to continue.

Enter your Company VAT Number.

Each VAT period requires a submission and typically ends on the last day of the month with the submission typically due on the 25th of the following month. Enter your last VAT Period End Date and your last VAT Submission Due Date. We will use these dates to determine your next VAT Period End Date and when your next VAT return is due.

Click on the Next button:

Click on the Finish button.

 

 

Purpose of the VAT Returns and Reports Screen:

 

VAT is a strictly regulated area of any business and keeping your figures accurate, reliable and up to date is essential to avoid issues with the authorities. With the VAT Returns and Reports screen you will be able to control all of your VAT reporting from one central place.

Your VAT reporting does not always correlate to your financial reporting. Sometimes you will record transactions in one month and only account for the VAT in another month, this can often happen if you are behind on your processing.

With the VAT Returns and Reports Screen you will assigning transactions to particular VAT periods, and not specific date ranges.

Benefits of VAT Periods:

  • These should agree to what you actually submit to your local revenue authority.
  • Amounts owing should agree with the VAT payments that you have made.
  • No editing of transactions that have been submitted to the Revenue Authority.
  • Back dated transactions will pull through to the current VAT Period (i.e. no missing of VATTransactions).

The screen will display a list of all of your VAT Periods detailing relevant information pertaining to each period:

  • VAT payable or refundable for the period
  • Associated payments and refunds made for each period
  • Quick links to the VAT 201 and VAT Report relevant to that period

The following screen will be displayed:

The table below will explain all the fields on the screen above:

FieldExplanation
Close VATPeriodIf you select the Close VAT Period button, Accounting will close off the current VATperiod that you are working in and move over to the next VAT period.
Reopen (a previous VATPeriod)Reopening a VAT return should only be done if your intention is to resubmit your VAT to your revenue authority. For Example: All transactions in the VAT return for 12/2013 will be unmarked as finalised and you will be able to edit these transactions. Any transactions that have been back dated prior to and including 31/12/2013 and that have not been included in any other VAT return will be included in the 12/2013 VAT return once you close this VAT period.
Start Over?If you select this option, all of your VAT Returns will be removed and you will have to set it up again. The values for each return may differ to the actual returns you have submitted to your revenue authority. Please be careful before selecting this option. Consult with your financial practitioner.
View (Previous VAT 201 Calculation)This option allows you to view the VAT 201 Calculation report for a previous VATPeriod.
View (Previous VAT Report)This option allows you to view the VAT report for a previous VAT Period.
Payment/RefundYou can allocate your VAT Return amounts to the correct VAT period by selecting the Link Payment and Link Refund option.

You will also have access to your standard VAT Reports via the Reports button:

VAT Adjustments

In the VAT Adjustments screen, you are able to adjust either the input or output VAT (explained earlier in the manual).

You can make adjustments to the amount of VAT that you owe or are owed. You should therefore be certain of the amount you enter. All VAT adjustments will be included on the VAT Report.

You will need to specify whether the adjustment you are processing will affect Input VAT or Output VAT.

The following table will help you remember when input and output VAT applies:

VATTypeExplanation
Output VATIf you sell items to customers, which means items (stock) are leaving your business, it is referred to as output VAT.
Input VATIf you buy items from your suppliers, which mean you are receiving items (stock) into your business for resale or business use, it is referred to as input VAT.

Your accountant will process the required VAT adjustments for your business.

  • Select the Accountants Area…VAT Adjustments menu option.
  • The following screen will be displayed:

VAT Payments and Refunds

VAT reports must be submitted to your local VAT authority on a regular basis, and will either indicate that you need to pay VAT over or receive a refund.

Since the VAT laws of your country govern VAT processing, it is of extreme importance to ensure that you process the adjustments, payments and refunds correctly.

Accounting will calculate your VAT for you as shown below. Your Input VAT is calculated by establishing the VAT included on all purchases – item and non-item based – that you have processed in Accounting. Next, your Output VAT is calculated by establishing the VAT included in all of the sales – item and non-item based – that you have processed in Accounting. The difference between the two is the amount of VATthat you owe. If your input VAT is higher than your output VAT, you will be due a VAT refund.

You can process VAT payments and refunds that will automatically create a payment or receipt to your selected bank account.
You will see a VAT summary for the date range you have selected. To view any payments or refunds already processed print the VAT Payments and Refunds report. Any payment or refund processed in the date range you have selected will be excluded from this summary as they are considered to be payments or refunds pertaining to a previous VAT period.

In the Details screen, you will edit the date for the transaction and the bank account that will be affected. You will then enter the Reference and Description for the transaction. You are able to edit the value of the amount in the Detail section of the screen; however, this is not recommended.

To process the VAT Payment, click the Finish button.

The Different VAT Types

The supply of all goods and services attract VAT (standard rated supplies) unless the goods or services are zero-rated or VAT exempt. Certain goods and services attract VAT, but the purchaser is not allowed to claim the VAT input.

Standard Rated Supplies

A standard-rated supply is a supply of goods or services, which is subject to VAT at the rate of 15%. The supply of all goods and services are taxable at the standard rate, unless it is specifically zero-rated in terms of section 11, or exempt in terms of section 12 of the VAT Act.

The following are some examples of standard-rated supplies (the list is not exhaustive):

  • Land and buildings (fixed property) – commercial or residential property bought from property developers, building materials, vacant land bought from a vendor etc.
  • Fees for professional services – construction/building, estate agents, consultants, architects, engineers, project managers, doctors, private hospital services, lawyers, plumbers, electricians and accountants.
  • Household consumables and durable goods – most grocery items and foodstuffs such as meat, fish, white bread, snacks, most canned foods, cigarettes, perfume, medicines, cool drinks, cleaning materials, clothing, footwear, microwave ovens and other household consumables and appliances.
  • Municipal goods and services such as the supply of electricity, water and refuse removal.
  • Accommodation, hospitality, tourism and entertainment – restaurant meals, hotel accommodation, liquor sales, arcade amusements, casino slot machines and gambling services, entrance fees to sporting events, theatre performances and film shows, guided tours, game drives and game hunting expeditions.
  • Capital assets such as furniture, production machinery, installations, motor vehicles and equipment.
  • Local transport of goods (all modes of transport) and transport of passengers by air or sea.
  • Telephone, internet, computer and other telecommunication services.
  • Rental of goods and commercial property such as office space.
  • Motor vehicles, repair services, lubrication oils and spare parts.

When a standard rated supply is made, VAT (output VAT) must be charged at the prescribed rate (currently 15%) and input VAT may be deducted on any goods or services acquired in the course of making those taxable supplies. The net VAT due by a vendor is calculated by subtracting the input VATincurred from the output VAT charged during the VAT period.

Zero Rated Supply

Zero-rated supplies are taxable supplies on which VAT is levied at a rate of 0%. The application of the zero rate must be supported by documentary proof acceptable to the Commissioner.

Some examples of zero-rated supplies are briefly explained below:

Certain basic foodstuffs

Certain basic foodstuffs are zero-rated, provided it is not supplied for immediate consumption (that is, as a meal or refreshment) or added to a standard-rated supply.

These include the following:

  • brown bread
  • dried mealies and mealie rice
  • brown bread flour (excluding wheaten bran)
  • samp
  • hens eggs (that is, not from ostriches, ducks etc.)
  • fresh fruit and vegetables
  • dried beans
  • lentils
  • maize meal
  • rice
  • pilchards in tins or cans
  • vegetable cooking oil (excluding olive oil)
  • milk, cultured milk, milk powder and dairy powder blend edible legumes and pulses of leguminous plants (that is, peas, beans, peanuts etc.)

The zero rate will not apply where:

  • Zero-rated foodstuffs are prepared for immediate consumption, for example:
    • a glass of milk served in a restaurant;
    • salad or fruit salad which is ready to eat; and
    • sandwiches and other take-away foods.
  • A standard rated product or ingredient is supplied together with a zero-rated foodstuff, for example:
    • a pack of vegetables containing a pack of flavoured butter;
    • a pack of rice or beans containing a sachet of flavouring;
    • a gift hamper consisting of a basket of fruit;
    • flavoured cooking oil; and
    • a pack of salad to which salad dressing has been added.

Fuel levy goods

Most motor fuels are subject to taxes such as the General Fuel Levy, the Road Accident Fund Levy as well as Excise duty. The VAT Act therefore provides that certain specified “fuel levy goods” are subject to the zero rate. These include crude oil and certain petrol and diesel based products, which are used as fuel in internal combustion engines.

Examples include:

Fuels used in motor cars, trucks, buses, ships, fishing boats, railway locomotives, farming and production machinery.

Petroleum oils and crude oil, which are refined for the production of fuel levy goods, are also zero-rated; however, aviation kerosene, motor oil, and oil lubricants are subject to the standard rate.

Exports

The direct export of goods may be zero-rated. In certain instances, the indirect export of goods may also qualify for the zero rate. In both cases, certain documentary and other requirements must be met to support the application of the zero rate.

Services physically performed outside the Republic

The supply of services physically rendered or performed outside the RSA qualifies for the zero rate. This provision will apply to both residents and non-residents.

For example, if a South African vendor constructs a building in Botswana for a RSA resident, those services are subject to VAT at the zero rate. This provision applies to services physically performed for a vendor in a customs controlled area.

Exempt Supplies

Exempt supplies are supplies of goods or services where VAT is not chargeable at either the standard rate or the zero rate and will not form part of taxable turnover. If a person makes only exempt supplies, that person cannot register as a vendor or charge VAT on those supplies. Accordingly, any VAT incurred to make exempt supplies may not be deducted as input VAT.

Some examples of exempt supplies include:

  • financial services (such as, interest earned for the provision of credit, life insurance, the services of benefit funds such as medical schemes, provident, pension and retirement annuity funds);
  • donated goods or services sold by non-profit bodies (such as, religious and welfare organisations);
  • residential accommodation in a dwelling (but not holiday accommodation);
  • passenger transport in South Africa by taxi, bus, or train;
  • educational services provided by recognised educational institutions such as, primary and secondary schools, technical colleges, or universities which have been approved as public benefit organisations; and
  • childcare services provided at crèches and after-school care centres.

Note that generally the liability to register for VAT does not depend on the status of the organisation itself, but rather on the type of supplies made. There is, however, an exception, which is applied in the case of public authorities.

Non-allowable items

Sometimes, although the Vendor charged VAT output, the subsequent acquirer of the goods or service may not claim VAT input on them.
Some of these products/services include:

  • Entertainment expenditure: Entertainment expenditure includes staff refreshments and other goods bought for the purposes of entertainment. SARS does not regard such items as necessities in producing VAT liable outputs, thus no VAT input claim will be allowed. There are exceptions to this rule, though: If the owner or an employee of a company is away on a business trip, then VAT input may be claimed on the hotel bill if the person stays over at the hotel for at least one night.
  • Passenger vehicles: However companies makes use of sedan vehicles and can prove that this type of vehicle is crucial to the nature of its business, it may apply for a special concession. If adequate proof is supplied, the company may be granted a proportional claim by SARS.
  • Club fees and subscriptions (with the exception of professional subscription fees in the case where a license is needed to trade).

The screen above will be displayed the first time you access this report.

The VAT 201 Calculation Report will assist you with the completion of your VAT 201 return. Please check the following before submitting your VAT return:

  • The correct date ranges have been selected for the VAT Period you are submitting your VAT return for.
  • All transactions for the VAT period concerned have been processed.
  • All transactions have been assigned to the correct VAT types.
    Click on the Next button to continue.

View Audit Report

You can drill down from your VAT 201 to the new VAT Audit Report to view transactions per VAT code.

VAT Reports

VAT Report

A VAT report lists VAT transactions for reporting purposes. This report is also available in the Reports menu. You have the option to print the report in detail or in summary, with or without VAT adjustments. You can also include payments and/or refunds in the report. You can set if the report must offset all the credits on sales or purchases.

Each VAT Report can be run either by VAT Period or by a selected Date Range.

You have the selection to preview the report as monthly, quarterly, yearly, month to date, quarter to date, year to date, life to date, custom to date, last month, last quarter and last year. If you select the custom dates option, you can select the date ranges from the calendar look up fields.

Check the Offset Credits on Sales / Purchases check box to offset credits against sales or purchases. Uncheck the check box to show these separately. This option only applies to customer and supplier credit transactions.

VAT Audit Report

This report lists all of the original Customer Tax Invoices and Credit Notes that were emailed and marked as Computer Generated.

Each VAT Report can be run either by VAT Period or by a selected Date Range.

 

 

VAT Payments and Refunds Report

This lists the payments made and refunds received from the revenue service.

Each VAT Report can be run either by VAT Period or by a selected Date Range.

VAT Summary Report

This report gives you an overview of your VAT position either per period or per month.

Each VAT Report can be run either by VAT Period or by a selected Date Range.

 

 

 

 

 

 

 

 

 

VAT Transactions Report

This is a detailed report showing the transactions making up your VAT Payable balance.

Each VAT Report can be run either by VAT Period or by a selected Date Range.

Process Journal Entries

Journals are posted to adjust account balances.

In the Process Journal Entries screen, you will first enter the account that will increase in value. Enter the date and reference for the transaction and then enter an explanation for the journal. If the journal requires a corresponding decreasing account, you will enter the value in the by Affecting Acc column. You can select to include VAT on the journal if necessary.

  • Select the Accountants Area…Journal Entries option.
  • The following screen will be displayed:

You can select to show previous journal entries that have been made. This can assist you in processing journals because you can see how previous adjustments or transactions were done.

In the grid, you will enter the transaction’s details. On the left side, you will process one side of the transaction. On the right side, you will select the other account that will be affected, if required. On the right, the system will automatically fill in the amount for you. Each of the fields in the lines are explained below.

The following table explains the grid columns:

ColumnContent
DateEnter the date on which you are processing the transaction.
EffectIn this field, you will select whether you want to enter a value to debit or credit the balance of the account.
AccountHere you will select the account that you need to adjust.
ReferenceIn this field, you will enter a reference for the transaction.
DescriptionIn this field you will enter a description for the adjustment. Remember to enter a description that is meaningful when it appears on reports.
VAT TypeYou are able to select whether the transaction has VAT on it or not.
AmountEnter the VAT exclusive value of the adjustment here.
VATEnter the VAT amount only in this field.
Incl. VATHere the system will display the VAT inclusive amount. This is also the amount that will be added or taken away from the balancing account.
By Affecting AccountThe “other” account affected when you post a transaction. The principle of accounting dictates that every debit should have a credit. In other words – every transaction affects at least two accounts. A main account and a contra account. The contra account is referred to as the by affecting account. For example: If you do a journal entry for depreciation for your Motor Vehicles. You will affect the depreciation account in the profit and loss – however, you need to affect a contra account as well. The By affecting account in this example would be The Motor Vehicles account which is an asset. In the example of a Customer Adjustment you would affect the Customer (or Accounts Receivable) but the by affecting account would be the other ledger account affected by the adjustment for example Interest Received.

User the   or   buttons to add or delete lines in the journal processing grid.

If you delete a transaction while you are processing or when you are viewing previous transactions, Accounting will not remove the deleted line immediately. The deleted lines will be displayed as deleted and an undo button will be available to un-delete the line. Once you click on the Process button, the transactions displayed as deleted will be deleted.

Trial Balance Export

In Accounting, you are able to export your trial balance to a .CSV file. This allows you to import the exported file into other .CSV compatible software.

You can also select to assign account numbers.

You access this function via the Accountant’s Area menu option.

Export without assigning account numbers

To export your trial balance, select your reporting period and viewing options.

Your date range options are:

MonthlySelect this option if you want to run the trial balance for a selected month.
YearlySelect this option if you want the trial balance to include only a year’s transactions.
Life to DateSelect this option if you want the trial balance to include all transactions from the start of the business.
This YearSelect this option if you want the trial balance to include only the current financial year’s transactions.
Last YearSelect this option if you want the trial balance to include only the previous financial year’s transactions.

Your viewing options are:

OptionsExplanationCalculation
Closing BalancesSelect this option if you want the trial balance to display account closing balances, including transactions from the beginning of the year up to the end of the selected month.Closing Balances = Opening Balances + any debit and credit transactions (per account) from the beginning of the year up to the selected month
MovementsSelect this option if you want the trial balance to only display accounts which had transactional activity for the selected date range. This will not include the opening balances of the accounts.Movements = Debit and Credit Transactions (per account)

After you have made your selection, click on the Export Data button. A File Download screen displays, allowing you to Open, Save or Cancel the exported “TrialBalance.csv” file.

Click on the Open button to view the exported Trial Balance, click on the Save button to save the file or click on the Cancel button if you do not want to continue with the export process.

The exported .CSV file contains, by default, the following column headings:

  • Account Code
  • Account Name
  • Date
  • Debit
  • Credit

The date that filters through to the .CSV file, is the last day of the selected date range.

If you wish to display your reporting group detail in the report, check the check box.

Export and assign account numbers

To export your trial balance and assign account numbers to the list of accounts, complete the screen by selecting your date range and viewing options.

Click on the Assign Account Numbers button.

The following screen displays:

Assign account numbers in the Account Number column by manually typing in a alphanumeric and/or numeric number.

You do not have to assign account numbers to all of the accounts.

These assigned account numbers will be saved for future exports.

Click on the Save button to save your account numbers and the system will return to the Export Trial Balance screen.

Click on the Export button to export your trial balance.

Accountant Reports

There are four reports available for accountants:

  • Trial Balance
  • Opening Balances and VAT Adjustments Report
  • Journal Entries
  • VAT Returns and Reports

You access these reports via the Accountant’s Area menu option.

Trial Balance

The trial balance is a list of all your accounts, including system accounts, for a selected date range. It is presented in a traditional accounting format and is used to ensure that your debit and credit transactions balance.

Select your reporting period. Your options are:

MonthlySelect this option if you want to run the trial balance for a selected month.
YearlySelect this option if you want the trial balance to include only a year’s transactions.
Life to DateSelect this option if you want the trial balance to include all transactions from the start of the business.
This YearSelect this option if you want the trial balance to include only the current financial year’s transactions.
Last YearSelect this option if you want the trial balance to include only the previous financial year’s transactions.

Your viewing options are:

OptionsExplanationCalculation
Closing BalancesSelect this option if you want the trial balance to display account closing balances, including transactions from the beginning of the year up to the end of the selected month.Closing Balances = Opening Balances + any debit and credit transactions (per account) from the beginning of the year up to the selected month
MovementsSelect this option if you want the trial balance to only display accounts which had transactional activity for the selected date range. This will not include the opening balances of the accounts.Movements = Debit and Credit Transactions (per account)

Take note of the following:

  • The trial balance consolidates the value of opening balances and VAT adjustments into the Opening Balances and VAT Adjustments account.
  • This account serves as the contra account for the individual transactions in the system. Drill down to view the transactions making up this account.
  • The trial balance uses the Cost of Sales based on Purchases calculation.
  • The trial balance consolidates the item opening balances, not the current value of your items, into the Item Opening Balance account. We recommend that you seek the advice of a financial professional to process the Item movement journal entries required to correctly display Items and Cost of Sales.

Opening Balances and VAT Adjustments

This report shows the transactions that make up the Opening Balances and VAT Adjustments system contra account displayed on the Trial Balance.

Journal Entries Report

This report displays all journals captured as well as audit information on the drill down.

 

 

 

 

 

 

Financial Statements

This section of the help file explains how account, customer and supplier transactions affect the different Financial Statements in Accounting.

The Financial Statements are the Profit and Loss Report and the Balance Sheet.

To know more about how Accounting Calculates the Financial Balances, click here.

Profit and Loss Report

When you generate a Profit and Loss Report the system will give you the option to calculate Cost of Sales based on Purchases or Sales.

If you are making use of Analysis Codes, select your project, departments and cost codes.

Select your date range in the date range drop down menu. You have the selection to preview the report as monthly, quarterly, yearly, month to date, quarter to date, year to date, life to date, custom to date, last month, last quarter and last year. If you select the custom dates option, you can select the date ranges from the calendar look up fields.

You can select to group the report by month or quarter in the Group By field. You can also compare all the amounts with the previous year amounts by ticking the Compare With Last Year tick box. If you want the report to display all your Reporting Group Detail, check the check box.

You can compare your profit and loss report with a budget that you created by ticking the Compare with Budget tick box.

You can also display a budget variance on the profit and loss report.

Select the Budget that you want to use in this report.

Select whether you want the cost of sales on the report to be displayed for Sales or Purchases.

If you are using Decimal Values, check this check box.

The Exclude Accounts option will only be available when running the profit and loss based on sales. When you run your Profit and Loss by sales, you have the option to exclude the Item Adjustments system accounts as well as any other Cost of Sales accounts you used to record your inventory movement on your balance sheet.

When you select to group the Profit and Loss report, the Print Report and Email Report options will grey out and you will only be able to view the report and export the amounts to Excel. A PDFversion of the report will not be available when you select Group By options or Comparatives.

This is an example of a Profit and Loss Report generated by Accounting:

You can change the dates to preview the report for in the Date Range drop down menus. Click on the Refresh button to refresh the details on the report.

The following table explains the Profit and Loss Report’s sections:

SectionsExplanation and CompositionCalculation
SalesThe Sales line reflects all of your items and service items that you have sold to your customers. This amount includes customers that are on a Cash on Delivery basis and customers that are 30 day accounts or more. The Sales section also includes all of the accounts that are assigned to the Sales Account Category, for example the Consulting Revenue.Sales = [Physical Item Sales + Service Item Sales] + Accounts assigned to Sales Category
Cost of Sales / PurchasesThe Cost of Sales / Purchases (COS) line reflects the amount you had to pay to acquire your physical or service items in order to sell them to your customers. These costs may include delivery charges that you had to pay to get the items to your premises, and so on. The COS section also includes all of the accounts that are assigned to the COS Account Category including Purchases described below.COS = [Cost of Physical Items Sold + Cost of Service Items Sold] + Accounts assigned to COSCategory
PurchasesThe Purchases line reflects the amount you paid to suppliers for items bought during the reporting period.These costs may include delivery charges that you had to pay to get the items to your premises, and so on.Purchases = [Physical Item Purchases + Service Item Purchases]
Item AdjustmentsThe Item Adjustments line reflects the value of all the item cost and quantity adjustments.Value of item adjustments
Gross ProfitThe Gross Profit section is the difference between your Sales and COS. If this amount is a positive amount, it indicates that you have made money. If this amount is a negative amount, it indicates that your COS were more than your sales, which indicates that you have not made money. This is a simple calculation.Sales – Cost of Sales = Gross Profit
Other IncomeThe Other Income section lists all of your other income accounts that generated income for the business. This may include additional services that you charged your customers for, such as delivery charges and so on. Accounting automatically includes discount received from suppliers for cash payment or for meeting payment terms.Total of Accounts linked to the Other Income Category including discounts received
ExpensesThe Expenses section lists all of your expenses that you have incurred to run the business such as salaries, operational costs (telephone, rent etc.) and it can also include monies that you had to pay suppliers for non-item based charges like penalty fees on late payments, interest on an overdue account, delivery charges and so on. Accounting automatically includes discounts allowed to customers for cash or early payment, as well as bad debts.Total of Accounts linked to the Expense Category including discounts allowed and bad debts
Net Profit/Loss before TaxThis section indicates if you have made a profit or loss after taking in account the Other Income and Expenses of your business before deducting Tax.Gross Profit + Other Income – Expenses = Net Profit/Loss before Tax
Income Tax ExpenseThis line includes the total of all the accounts assigned to the Income Tax Expense Account Category.Total of Accounts linked to the Income Tax Expense Account Category
Net Profit/Loss after TaxThis section indicates if you have made a profit or loss after taking the Tax payments of your business into account.Net Profit/Loss before Tax – Tax = Net Profit/Loss after Tax

Remember that you can drill down to specific reports from the preview of the Profit and Loss Statement and any other report. From the Profit and Loss Statement, click on any line and a specific report will display detailing how the amount was calculated.

Balance Sheet

This is an example of a Balance Sheet generated by Accounting:

The following table explains the Balance Sheets’ sections:

SectionsExplanation and CompositionCalculation
Non-Current AssetsYour Non-Current Assets, previously known as Fixed Assets, are assets that are not easily converted into cash, such as property, motor vehicles and equipment. This section includes all of the accounts that are assigned to the Non-Current Asset Account Category.Non-Current Assets = Accounts assigned to the Non-Current Assets Account Category
Current AssetsCurrent Assets are those assets that are expected to generate income for the business within a specified time frame, usually a year. This section includes Items, Trade Receivables and all your Bank and Credit Card Accounts. This section also includes all of the accounts that are assigned to the Current Asset Account Category.Current Assets = [Items+Trade Receivables + Bank and Credit Card Accounts] + Account assigned to Current Asset Account Category
Non-Current LiabilitiesA Liability is defined as an obligation of an entity arising from past transactions or events, such as loans and tax. A Non-Current Liability, previously known as Long Term Liability, is a liability that will not be settled within the next Financial Year. This section includes all of the accounts that are assigned to the Non-Current Liabilities Account Category.Non-Current Liabilities = Accounts assigned to the Non-Current Liabilities Account Category
Current LiabilitiesA Current Liability is a liability that is expected to be settled within the current Financial Year. This section includes Trade Payables, Tax Payable and all of the Accounts assigned to the Current Liability Account Category.Current Liabilities = [Trade Payables + Tax Payable] + Accounts assigned to the Current Liabilities Account Category
Nett Asset/Liability ValueThis value represents the solvency of your business which means the ability of a business to cover its debts with its assets. Solvency can also be described as the ability of a business to meet its long-term fixed expenditure and to accomplish long-term expansion and growth. The better a company’s solvency, the better it is financially. When a company is insolvent, it means that it can no longer operate and is undergoing bankruptcy. Solvency is a different concept from profitability, which refers to the ability to earn a profit. Businesses can be profitable without being solvent (for example, when they are expanding rapidly). Businesses can be solvent even while losing money.Nett Asset/Liability Value = Total Assets – Total Liabilities

Remember that you can drill down to specific reports from the preview of the Balance Sheet and any other report. For example, from the Balance Sheet, click on the Tax Payable line for the Tax Report to display.

How does Accounting Calculate Financial Balances?

Accounting maintains the following “system accounts” which are calculated for the financial reports based on processed transactions:

Profit and Loss Report

System AccountsCalculation
SalesThis is the total of all your Item sales, exclusive of VAT.
Cost of Sales/PurchasesThis is the Cost of all physical Item Sales, based on the weighted average cost of the Item at the time of sale, plus the Cost of all service Item Purchases.
PurchasesThis is the total of all your items bought, exclusive of VAT.
Item AdjustmentsThis is the total of all item adjustments.
Discount ReceivedThis is the total of all discounts applied when processing payments to Suppliers.
Discount AllowedThis is the total of all discounts applied when processing receipts from Customers.
Bad DebtsThis is the total of all Customer Write-Offs.

 

 

 

 

 

 

Balance Sheet

System AccountsCalculation
Trade ReceivablesThis is the total of all outstanding Customer balances.
ItemsThis is the value of all Items on hand. The value of an Item is calculated as: [The Quantity on hand at the time of the report] x [The Average Cost of the Item at the time of the report (calculated chronologically based on the date the transactions were processed) in Sage One Accounting]
Bank AccountsThis is the balance on the respective Bank and Credit Card Accounts. These balances are affected by Customer Receipts, Supplier Payments, Account Receipts and Payments, and VAT Payments and Refunds.
Trade PayablesThis is the total of all outstanding Supplier balances.
VATPayable (Invoiced Based)This is the total of all Output VAT on Sales, less all Input VAT on Purchases and includes any VAT Payments or Refunds and VAT Adjustments.
VATPayable (Payments Based)This is the total of all Output VAT on Receipts, less all Input VAT on payments and includes any VAT Payments or Refunds and VAT Adjustments.
VATProvisionWhen you use the Payment Based VAT system, the VAT provision account accumulates the VAT amounts of unpaid customer and supplier invoices.

Accountants Area