EXCEL-SKILLS.

COM

BASIC ACCOUNTING TEMPLATE

This innovative accounting template enables users to record income & expenses and automa
cash flow statement and balance sheet. The template is easy to use and can be customiz
unlimited number of additional accounts. It also accommodates sales tax calculations and m
template setup, the template can be rolled forward or back by simply changing the reporting ye

Get the full version of the template to unlock all the form
This is only a sample file created to show you the design of the te
version of the template where you have full access to all areas of the
to edit and customize the full version just like any of your own Excel fi

Get the full version of this template!

enable editing to activate the link

MPLATE
ord income & expenses and automatically produces a trial balance, income statement,
s easy to use and can be customized by editing the default accounts and adding an
modates sales tax calculations and multiple bank accounts. After completing the initial
by simply changing the reporting year in a single input cell.

emplate to unlock all the formulas!

d to show you the design of the template. Get the full version for a fully unprotected
u have full access to all areas of the template including all formulas. You will also be able
sion just like any of your own Excel files.

version of this template!

e editing to activate the link

come statement,
s and adding an
pleting the initial

fully unprotected
u will also be able
Excel Skills | Basic Accounting Template
Instructions
[Link]

This innovative accounting template enables users to record income & expenses and automatically produces a trial balance,
statement and balance sheet. The template is easy to use and can be customized by editing the default accounts and ad
additional accounts. It also accommodates sales tax calculations and multiple bank accounts. After completing the initial templa
rolled forward or back by simply changing the reporting year in a single input cell.

Note: The main difference between our Basic Accounting and Service Based Accounting templates is that the Service Bas
includes customer details and invoicing. If you do not need to produce invoices for customers, the Basic Accounting template sh

The template includes the following sheets:

Setup - enter your business name to change the headings on all the sheets and customize the sales tax codes and bank c
percentages are used to calculate sales tax on all income & expense transactions and bank codes can be used to allocate
accounts. The first financial year, reporting year and year-end input cells determine the monthly periods that are included
statement, cash flow statement and balance sheet.
Groups - this sheet contains the default list of account groups that are used in this template. You can customize the descriptio
we do not recommend changing the account group keys. Additional account groups can be added and inserted in the approp
statement, cash flow statement and balance sheet.
TB - this sheet contains a full list of the accounts that are included in the template and a trial balance which is automatic
transactions that are entered on the Income and Expenses sheets. The default accounts list can be customized by editing
inserting new rows for additional accounts. The period for which the trial balance is calculated is determined by the month-end
top of the sheet in column G.
Income - all income and other receipt transactions should be entered on this sheet. The columns with yellow column heading
columns with light blue column headings contain formulas and are therefore automatically calculated.
Expenses - all expense and other payment transactions should be entered on this sheet. The columns with yellow column hea
the columns with light blue column headings contain formulas and are therefore automatically calculated. We also recommen
sheet.

IS - the monthly income statement on this sheet is automatically compiled based on the transactions that are recorded on the In
The 12 monthly periods that are included in the report are determined based on the reporting year that is specified on the Setup

CFS - the monthly cash flow statement on this sheet is automatically compiled based on the income statement and balance she

BS - the monthly balance sheet on this sheet is automatically compiled based on the transactions that are recorded on the Inco
the line items are set to report account group totals but you can include individual accounts by changing the keys in column A.
Bank - this sheet contains an analysis of bank account movements on a daily basis (for the selected month) and on a monthly
year. Aside from selecting the bank code and month, no user input is required on this sheet.
SalesTax - this sheet contains a monthly sales tax analysis which can be used for sales tax returns. All the calculations are au
tax type and any of the individual sales tax codes at the top of the sheet to view the output and input values for any tax type o
types for national or federal sales tax and state sales tax.

Setup

The first step in setting up the template for your business is to enter your business name at the top of the Setup sheet. Your bu
heading on all the other sheets. You also need to enter the first financial year & the reporting year, select a year-end month a
bank codes on the Setup sheet.

The first financial year that is entered on the Setup sheet is very important because it determines the first period that will
calculations. The year that is specified in this input cell also determines the effective date for which opening balance sheet ba
column C on the TB sheet.

Page 4 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

Note: Once you have set the first financial year that needs to be included in the template, you need to use a trial balance a
financial year (as generated in your previous accounting solution) to enter the balance sheet opening balances in column C on
the balance sheet opening balances needs to be nil in order for the balance sheet to balance.

This template can only be used for full financial years. The template does not make provision for entering opening balances for
you therefore need to start with data for a full financial year. If you therefore switch from another accounting solution to our tem
all your income & expenses as from the first day of the first financial year that is included in the template.

The reporting year that is entered on the Setup sheet determines the 12 monthly periods that are included on the income sta
and balance sheet. The IS, CFS and BS sheets include 12 monthly periods - these periods and the calculations that are auto
sheets can therefore be amended by simply changing the reporting year on the Setup sheet to include a new 12-month financia

Note: The first financial year basically needs to be set once when you start using the template but the reporting year can b
financial period that is included in the template forward or back by simply changing the year in this cell. The template can be us
and all template calculations are updated automatically when you change the reporting year.

You also need to select the appropriate year-end month from an input cell on the Setup sheet. This selection is used to determi
date of each financial year and also determines the date on which opening balance sheet balances need to be included on the T

Sales Tax Codes

The template accommodates an unlimited number of sales tax codes. You can include as many sales tax codes as you wan
sales tax codes on the Setup sheet and adding additional sales tax codes by inserting the required number of additional rows, e
letters between A and Z) and entering the appropriate sales tax percentage.

The sales tax codes included in the list on the Setup sheet are automatically included in the drop-down lists in the Sales Tax C
and Expenses sheets and the relevant percentages are automatically used to calculate the sales tax amounts on the same sh
for two default sales tax types - national or federal sales tax and state sales tax and each sales tax type therefore has its ow
columns.

All the sales tax codes are available in both sales tax columns but you can use different sales tax codes and therefore differen
federal sales tax and state sales tax by simply selecting the relevant codes in the appropriate column which automatically result
percentage being applied to the sales tax calculations. If the sales tax percentages change, you can simply create a new
percentage and use it from the effective date for the new sales tax percentage.

If you do not need sales tax to be calculated, you can simply leave the sales tax code columns blank or select any code with a z
sheet which will result in no sales tax being calculated.

If you do not need both sales tax columns, we recommend selecting the appropriate sales tax codes in the first column and sim
tax code column blank or using a sales tax code with a zero percentage which would result in no sales tax being calculated in
column. You can delete the second sales tax code and amount columns without affecting the sales tax calculations in the firs
columns but it may result in a data validation warning being displayed in the first sales tax amount column. These warnings just
the second sales tax calculations in the formulas and can safely be ignored.

Page 5 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

We have also included a SalesTax sheet which is automatically calculated and requires no user input. This sheet contains a
amounts and can be used to populate sales tax returns. The calculations can also be displayed for a specific sales tax c
appropriate code from the list box at the top of the sheet. When you then clear the contents of the list box, totals for all sales tax

Bank Accounts

The template also accommodates an unlimited number of bank accounts. You can include as many bank accounts as you wan
bank account codes on the Setup sheet and adding additional bank account codes by inserting the required number of additiona
and entering a description of the bank account. You also then need to copy the formulas in columns D and E (indicated with lig
one of the existing bank account codes.

Note: When adding bank account codes, we recommend inserting new rows anywhere above the JC bank account code and
code for all new bank accounts. The JC bank account code is reserved for journal entries and the default code for this bank c
Journals do not really have a cash effect but we are using the JC code to facilitate including general ledger journal type entries i

All the bank codes that are added to the Setup sheet are automatically included in the drop-down list boxes on the Income a
available for selection immediately after being added to the Setup sheet. If the default number of bank account codes (fou
sufficient for your requirements and you have added additional bank account codes to the Setup sheet, you also need to add
the TB and BS sheets.

Note: It is very important that you add the additional bank account codes to the TB and BS sheets otherwise your trial balanc
balance!

The bank accounts on the TB sheet are part of the control accounts section at the bottom of the sheet. If you need to ad
recommend doing so above the JC bank account (BS-BJC bank code in column A). Adding the additional bank account codes
the required number of additional rows and copy the formulas from one of the existing bank account rows. The template will au
account codes in the same sequence as they are included on the Setup sheet.

After adding the additional bank account codes to the TB sheet, you also need to add the new codes to the BS sheet. The proc
simple - insert the required number of additional rows above the JC bank account code (BS-BJC key in column A) and copy
existing rows. You can copy the entire row to ensure that you have included the formulas in all columns. The formulas will aut
bank account codes.

Note: If an additional bank account has been added to the Setup sheet and not included on the TB or BS sheets, the appropri
status in column D or E. This indicates that the bank account still needs to be added to the appropriate sheet.

Note: We have also included a Bank sheet in the template which enables users to analyse bank account movements in a lot
preparing bank reconciliations. This sheet enables users to select a bank account code and month at the top of the sheet
monthly bank account movements. Aside from selecting the bank code and month, the sheet requires no user input.

Input Error Codes

The input error codes at the bottom of the sheet are included for information purposes only and provide users with a reason fo
encountered when entering transactions on the Income and Expenses sheets. These error codes are covered in more detail
these instructions.

Account Groups

Page 6 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

The accounts that are included on the income statement, cash flow statement and balance sheet are based on a pre-defi
consists of pre-defined account groups that are used to populate the appropriate line items. A detailed list of these account grou
sheet.

Note: Changes to the Groups sheet do not influence any of the calculations on the other sheets and only have an effect on th
that are included on the IS, CFS and BS sheets. If you want to make changes to our default account groups, we only recom
necessary and that you customize existing account groups before considering adding new account groups. Customizing sim
which are not required is a lot easier than adding new account groups.

Note: If you do not change any of the default account groups, it is not necessary to review the rest of the instructions in the Acco

The description of line items on the balance sheet can be changed quite easily by changing the description of the appropriate a
sheet and then changing the account descriptions of the appropriate accounts which are included in the account group on the T
accommodate up to 100 individual accounts which are linked to the account group by the same first 5 account number characte

Example: The account group key for property, plant & equipment (cost) is BS-00 and the account group is included as a grou
(key of BS-00G) which means that all accounts that start with BS-00 will be included in this account group total on the balanc
number for Land & Buildings (cost) is BS-0005 which starts with BS-00 and therefore forms part of this account group.

The same account integration principle is applied to most balance sheet account groups where the default integration is to re
indicated by the "G" at the end of the account group keys). Although it is not difficult to add new account group keys to the Grou
the new keys in the balance sheet or income statement, there is a risk of balance sheet imbalances occurring if the cash flow s
included correctly. We therefore recommend completing the following steps if you want to add new account groups to the i
sheet:

■ Scan the Groups sheet for similar items which you are not going to use. For an item to be similar, it needs to be of the sam
want to add. For example, current assets can only be replaced by other current assets and liabilities can only be replaced b
differ in nature, you should add a new account group instead of using an existing one.

■ If no suitable existing item can be found, insert a new row and add a new account group by entering the appropriate accoun
for the account group. When adding keys, you need to stick to the principle of a five character key which is unique and acco
linked to this key, need to also start with the same five characters followed by a number between 00 and 99.
■ When adding new account groups, we suggest using the next available account group number after the "BS-". The default b
end after "BS-20" which means that the first available account group is "BS-21". The default income statement account gro
means that the first available account group is "IS-11".

■ After adding the appropriate account group to the Groups sheet, go to the TB sheet and add the required individual accounts
the account group total on the balance sheet. Remember that the appropriate account numbers all need to start with the sam
account group and refer to the New Accounts section of these instructions for guidance on adding new accounts to the TB shee

■ Next, you need to add the new account group to the income statement or balance sheet. This is relatively simple - find a
balance sheet item, insert a row above or below it, copy the entire row from the existing item into the new empty row and the
column A so that the new account group that you just created on the Groups sheet will be included in the calculations in the n
new account group has been created as BS-21, the key in column A on the balance sheet should be "BS-21G". Only simil
column A should be used - the items with orange keys are custom formulas which cannot be copied for similar line items!

■ After adding the new account group to either the income statement or balance sheet, make sure that the total that this item
most income statement or balance sheet items, this should automatically be the case but in some instances especially with rega
you may need to edit some of the default formulas to ensure that the new account group is taken into account in the relevant tot

Page 7 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

■ Next, if you have added a new balance sheet account group, you will also need to make changes to the cash flow statement
included in a cash flow statement by including a profit or loss from the income statement and it therefore probably won't be ne
the cash flow statement if you have added a new income statement account group.
■ If necessary, find a similar balance sheet item on the cash flow statement (CFS sheet), insert a new row above or below it,
existing, similar line item and enter the new key in column A. Only similar items with a green key in column A should be used
are custom formulas which cannot be copied for similar line items!
■ You also need to ensure that the appropriate total on the cash flow statement includes the new account group which has
balance sheet may not balance.

As you can see, it becomes relatively complex when needing to add new account groups to the template and it is therefore
descriptions of one of the existing line items in order to accommodate new or renamed account groups.

Note: Refer to the Account Integration section of the instructions for guidance on how to include individual accounts on the i
sheet. This section is part of the main Trial Balance section below.

Chart Of Accounts & Trial Balance

The TB sheet has a dual purpose - it contains the chart of accounts which represents a detailed list of the account number
allocation of transactions & the reporting of transaction totals and it contains a detailed trial balance which is automatica
transactions that are recorded on the Income and Expenses sheets and allocated to accounts in the Account Number columns.

Chart of Accounts

The default chart of accounts on the TB sheet includes all the individual accounts that have been created in each of the defa
groups constitute the first 5 characters of the account number and the individual account numbers are represented by the next
numbers. Each account group can therefore accommodate up to 100 account numbers (00 to 99).

Note: The template has been designed based on a fixed account number format. All account numbers start with a two ch
whether an account is an income statement account (IS) or a balance sheet account (BS) followed by a hyphen, the two-digit ac
Groups sheet) and a two-digit account number. This default account number format should not be deviated from otherwise the t
be accurate.

The template can be customized for your business by reviewing the accounts that are included for each account group (as per
the account descriptions in column B (where required) and inserting additional accounts if the number of accounts that are prov
accounts are not sufficient.

Additional accounts can be created on the TB sheet by inserting a new row, entering the appropriate account number, enterin
copying the formulas in columns E to H from one of the existing rows. We also recommend inserting the new row in the appro
account number sequence (in an ascending order). The list boxes in the Account Number columns on the Income and E
accounts in the same sequence as on the TB sheet - if account numbers are therefore not added in the correct order, it may
accounts.

Note: All new accounts need to be created within the existing account group structure (as per the Groups sheet) otherwise the t
be accurate and your balance sheet may not balance. New account groups can be created as per the Account Groups section o

Note: You can also delete any of the default accounts that are included in the chart of accounts on the TB sheet if they are no
Just be careful when doing so - if you have allocated transactions to an account and you subsequently delete it, it may
imbalances!

Account Integration

Page 8 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

The template provides for including accounts as a group total or as individual accounts on the income statement, cash flow sta
an account is integrated on an account group basis on the IS, CFS or BS sheets, the key in column A should contain the accou
a "G". If an account is integrated on an individual account basis, the key in column A on the IS, CFS or BS sheets should be th
additional characters at the end.

Note: If the accounts in an account group are integrated on an individual account number basis, you need to manually add all
appropriate sheet in order to ensure that all accounts that are included in the appropriate account group are included on
individual account in the appropriate account group is omitted and transactions are allocated to it, the balance sheet may not ba

If you stick to the default account numbers and do not add any new accounts, you do not need to be concerned about the inte
will be included correctly. If you make changes to the account groups or account numbers, it is important to ensure that you ha
accounts where necessary otherwise the template calculations may become inaccurate.

We have therefore added an account status in column H on the TB sheet where it is necessary to check the integration of a
control accounts). This column can have any of the following statuses:
■ Group - individual account balances will be included as a group total on the income statement or balance sheet.
■ Account - individual account balances will be included on the income statement or balance sheet.
■ Error! - this status means that an account number has been created but no integration could be found for the new account n
account number format that you have entered and correct it if necessary. If the account number is correct, the error is proba
number not being included on the income statement or balance sheet.

■ Double! - this status means that an account number integration has been added for the account number on both the ind
account group basis. If the integration for an account group is set up in such a way that accounts are integrated individually, y
accounts on a group basis because the affected account balances will be included twice. The template calculations will be
integration. If individual account integration is applied, all the individual accounts that form part of an account group need to b
income statement or balance sheet.

Note: If any row on the TB sheet contains an error or double status, the appropriate cell will be highlighted in red until the error
result in imbalances on the balance sheet and therefore need to be fixed before the template calculations will be accurate.

Note: Only the Income and Expenses account groups (excluding interest, taxation, dividends & other income and expenses) a
account basis by default. If you therefore add additional accounts to these account groups or change any of the default accoun
you will need to manually make the same changes to the appropriate items on the IS sheet.

Note: If you need to add a line to any section of the income statement or balance sheet, insert a new row in the appropriate loc
columns from one of the existing rows and change the key in column A to the appropriate full account number. The
automatically and the error on the TB sheet in the Status column should be resolved.

Control Accounts

Control accounts are accounts that have a specific purpose in the context of the template design and can therefore not b
allocation of transactions. These accounts are automatically calculated based on the transactions that are recorded on the Inc
are included individually on the balance sheet and cash flow statement. This is also why all the control accounts are included in
other accounts on the TB sheet.

Note: Control accounts include all the individual bank accounts, a trade debtors account, trade creditors account and a retain
accounts are integral to the proper functioning of the template and should not be amended in any way (aside from adding
required).

Page 9 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

Opening Balances

If you are using the template for an existing business, you will need to enter the appropriate balance sheet opening balances as
the first financial year that is included in the template (as specified on the Setup sheet) in column C on the TB sheet. The temp
financial years and opening balances can therefore only be entered for balance sheet accounts.

If you switch to our accounting template during the financial year, you need to enter the balance sheet accounts opening balan
year as the template opening balances in column C on the TB sheet and record all transactions from the first day of the finan
Expenses sheets.

Note: The balance sheet opening balances should be based on a trial balance produced in your previous accounting solution
year immediately before the first financial year that is included in the template. After entering all the opening balances, you als
total at the bottom of the TB sheet is nil otherwise your balance sheet will not balance.

Note: The opening balances of all asset accounts should be entered as positive values and the opening balances of all liability
entered as negative values. This should be exactly as they are reflected on the trial balance in your previous accounting softwar

All the opening balances that need to be entered on the TB sheet contain yellow cell backgrounds. The opening balances for
the trade debtors line and the trade creditors line in the Control Accounts section however contain light blue cell backg
subsequent movement in these opening balances will have an effect on the cash flow during the first financial period incl
opening balances should therefore be entered on the Income or Expenses sheets and will be calculated automatically on
formulas which have been included in column C.

Note: The total of all opening balances in column C on the TB sheet should still be nil and the formulas in the cells with light
control accounts section should not be amended in any way or replaced by values otherwise the template calculations will
column C is not nil, it is not as a result of any formula but as a result of opening balances not being entered correctly. DO NOT c
the cells with light blue cell backgrounds!

The opening balance for each of the bank codes that are included on the Setup sheet should be entered on the Income s
month-end date of the month that precedes the first financial year which is specified on the Setup sheet should be entered in th
payment date columns. This approach will ensure that the opening bank balances are calculated correctly on the TB sheet.

Example: If the opening B1 bank balance is $5,000 and the first day of the financial year is 1 March, an opening bank bala
recorded on the Income sheet with an inclusive invoice amount of $5,000, a document date & payment date of 28 February, an
a zero sales tax percentage), a bank code of B1 and a payment amount of $5,000. This balance will then be included automati
balance in column C on the TB sheet.

The opening trade debtors balance should also be entered on the Income sheet. You can enter the total in one row or en
individually (we recommend the latter because all outstanding invoices may not be paid on the same date). The invoice date
should be before the first day of the first financial year that is specified on the Setup sheet and the payment date should be the
will obviously be after the first day of the first financial year that is included in the template because the invoice is outstanding
financial year).

Example: If a company's year-end is February and the opening trade debtor balance at 28 February of the year before the
included in the template consists of two invoices, enter the actual invoice dates in the Invoice Date column (the invoices sho
February). The payment date can be left blank until the invoices are paid and the actual date when the payment is received sho
with the payment amount in the Payment Amount column. The opening trade debtor balance will then automatically be calcul
sheet.

Page 10 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

The opening trade creditors balance should be entered on the Expenses sheet (as a positive amount). You can enter the
outstanding invoices individually (we recommend the latter because all outstanding invoices may not be paid on the same d
paid to different suppliers). The document date should be before the first day of the first financial year that is included in the
sheet) and the payment date should be left blank until the appropriate supplier has been paid.

Example: If the opening trade creditor balance at 1 March consists of two invoices, enter the actual invoice dates in the Docume
should be dated on or before 28 February). The payment date column can be left blank until the invoices are paid and the actu
paid then needs to be entered in the Payment Date column. The opening trade creditors balance will then be calculated autom
TB sheet as a negative amount because trade creditors are liabilities.

Note: When recording opening balances for bank accounts, trade debtors and trade creditors on the Income and Expen
assigning these entries to a balance sheet account and using a sales tax code which does not result in the calculation of sale
template). Any balance sheet account can be used but we recommend using account BS-0799 which is the Cash Transfer Cont

Trial Balance

The TB sheet effectively combines the chart of accounts and trial balance features. The trial balance consists of the opening
reporting period (which is specified on the Setup sheet), the account movement for the appropriate financial year and the clos
selected monthly period during the current financial year. All of these trial balance calculations are automatically calculated an
on the TB sheet.

Note: The closing balances in column G are calculated based on the monthly period which is selected at the top of the sheet
background. If the reporting year on the Setup sheet is amended in such a way that the selected monthly period does not fa
year, this cell will be highlighted in red. You then need to select a valid month in order for the red highlighting to be removed.

The monthly periods that are available for selection are the same as the monthly periods that are included on the monthly
statement and balance sheet. You are therefore able to view a trial balance for any of the monthly periods in the current finan
the appropriate monthly period from the list box at the top of column G.

A trail balance for any previous financial period which has been included in the template can also be viewed by simply chang
Setup sheet and then selecting the appropriate monthly period from the list box at the top of column G on the TB sheet.

Adding new bank accounts

The template includes five default bank codes but you can add an unlimited number of additional bank codes (or accounts) by
account codes & descriptions to the Setup sheet. The new bank codes then also need to be added manually to the control
sheet.

This is actually a very simple exercise - simply insert the required number of new rows anywhere between the existing bank ac
section and copy the entire row from one of the existing bank account rows. All the formulas are automatically calculated & u
codes.

Note: Also remember that opening balances for all bank accounts need to be recorded on the Income sheet. If you add additio
sheet, the opening balances also need to be added to the Income sheet.

Recording Transactions - Income

Page 11 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

All income and other receipt transactions should be recorded on the Income sheet. User input is only required in the columns
All the columns with light blue column headings contain formulas which are automatically copied when adding new transactions

Note: All the columns on the Income sheet have been included in an Excel table. This feature is extremely useful when en
because the formulas that are included in calculated columns (the columns with light blue column headings) are automaticall
inserted into the table or when data is entered into the first blank row below the table. You can therefore enter a new trans
invoice number in column A - the table will then automatically extend to include the new transaction.

The Income sheet contains the following user input columns:

Invoice Number - enter your invoice number or the appropriate transaction reference for cash receipt transactions. This colu
value - if you do not issue document numbers for all your invoices & receipts, any unique transaction reference can be used.
Invoice Date - enter the date of the tax invoice or the bank statement date for cash receipt transactions. We've added data
ensure that only valid dates are entered - you therefore need to ensure that you enter dates in accordance with the regional da
in the System Control Panel.
Customer - enter the name of the customer. If the Auto Complete feature is enabled, you should be able to accept its sugg
after entering only a few characters. Note that it is important to enter customer names accurately if you want to use the Filt
transactions for a specific customer.
Description - enter a transaction description in this column.

Tax Inclusive Amount - enter the transaction amount inclusive of sales tax. Income and receipts should be entered as positiv
expense or payment type transaction that is of an income or receipt nature, the transaction can be entered as a negative va
credit note that relates to an invoice that has been recorded previously. In most instances, expenses should however be recorde
Tax 1 Code - this column contains a drop-down list which enables you to select one of the tax codes on to the Setup sheet an
or federal sales tax. The sales tax percentage applied to the transaction is determined based on the selected sales tax c
registered for sales tax purposes, all transactions should be recorded by using a sales tax code with a zero percentage. If no s
sales tax will be calculated.
Tax 2 Code - this column contains a drop-down list which enables you to select one of the tax codes on to the Setup sheet
sales tax. The sales tax percentage applied to the transaction is determined based on the selected sales tax code. If your b
sales tax purposes, all transactions should be recorded by using a sales tax code with a zero percentage. If no sales tax code
be calculated.

Bank Code - this column contains a drop-down list which includes all the bank codes that have been added to the Setup sheet
bank account that will be affected by the particular transaction. Note that it is imperative that a bank code is assigned to each tra
Account Number - the drop-down list in this column contains all the account codes (and descriptions) that have been cr
therefore need to create the appropriate account on the TB sheet before transactions can be allocated to the account. An
selected for every transaction otherwise template imbalances may be encountered.
Payment Amount - when a customer pays an invoice, the payment amount should be entered into this column.

Payment Date - enter the actual payment date in this column. The date that should be entered in this column should be the da
received from the customer. The payment date and payment amount should be left blank if payment has not been receiv
outstanding amount will then be included in trade debtors. Note that the payment date should always be greater than or equal to

The Income sheet contains the following calculated columns:

Outstanding Balance - if an invoice has not been paid in full, the outstanding balance will be reflected in this column.
determined based on the balance date that is entered in cell L2 at the top of the sheet. If the balance date contains no value, th
used to determine which invoices are currently outstanding. You can therefore use the balance date input cell to calculate the
any user defined date.

Exclusive Amount - the formula in this column deducts the sales tax amounts from the inclusive invoice amount in order to c
sales tax. For accounting purposes, the exclusive amounts are allocated to the income statement, the sales tax amounts are
sales tax control accounts and the inclusive amounts are allocated to trade debtors or bank (depending on whether the amounts

Page 12 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

Sales Tax 1 Amount - this column contains a formula which calculates the national or federal sales tax amount based on the t
F. Sales tax will only be calculated if a sales tax code has been selected in column F. The calculation is based on the sales tax
Setup sheet.
Sales Tax 2 Amount - this column contains a formula which calculates the state sales tax amount based on the tax 2 code se
will only be calculated if a sales tax code has been selected in column G. The calculation is based on the sales tax percen
sheet.
Inclusive Amount - this column is based on the inclusive invoice amount which the user enters in column E.
Unique INV - the formula in this column is used to determine whether the invoice number is unique. Invoices can be ente
formula is used to prevent the duplication of the calculation of outstanding invoice balances.

Error Code - this column will contain an error code if there is a problem with the input in any of the previous columns. All the e
in this column should therefore be corrected in order to ensure that all the template calculations remain accurate. Refer to the
instructions for more information about the reasons for an error code and how to resolve it.

Note: The drop-down lists in the Account Number column contains both the account number and description but only the
selected when allocating transactions. Excel doesn't actually allow the inclusion of two columns in a drop-down list but we have
to provide the account description together with the account number in the drop-down list. The disadvantage of this work aroun
to enter account numbers - you either need to select the account number from the list or copy a similar transaction that yo
column will also contain an error indicator which refers to a data validation error - this is to be expected because of the work
and can safely be ignored.

All the transactions entered on the Income sheet are automatically updated to the other sheets in this template. It is therefore im
are entered according to the guidance outlined in this section of the instructions otherwise it could result in imbalances in the tem

Filtering Transactions

All the column headings on this sheet contain a filter selection arrow - this feature indicates that the Filter feature has been
sheet. This Excel feature is very useful when you need to filter the data that forms part of a table based on the filter criteria whi
the selection arrow.

Example: If you only want to display the income transactions for a particular invoice or payment month, you can filter the data
Payment Date column by selecting the appropriate date filter from the filter menu which is displayed after clicking the selecti
filtered data, simply select the "Clear filter" option in the filtered column in order to remove the filter and to display all the transac

Note that the visible row numbers are typically displayed in blue when a filter has been applied to the sheet. New transactions s
filter is active on the sheet - if you see blue row numbers, all filters need to be removed before data is entered in the next blank
may not extend automatically to include the new transaction.

The sheet also contains totals above the column headings for all columns which contain values and which are suitable for
totals. The formulas in these cells result in only the transactions which are visible on the worksheet being included in the calcula
If you therefore print the sheet while a filter is in effect, the totals above the column headings will be calculated accurately and
which have been printed.

Invoices with Multiple Lines

If an invoice consists of multiple lines, the invoice needs to be entered by repeating the invoice number, invoice date and cu
relating to the invoice. When the invoice is paid in full, the payment dates need to be repeated in all the lines relating to t
payment amounts can be copied from the inclusive invoice values for each line.

Page 13 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

If a multiple line invoice is partially paid, the payment date and payment amount of the first payment can be entered in the firs
invoice and the other lines need to be left blank. This will ensure that the outstanding invoice balance contains only the part
been paid. When the next payment is made, the next payment amount and date needs to be entered and if there is still an unp
the outstanding balance calculation.

Partial Payments

If a partial payment of an invoice occurs, you should only enter the amount that has actually been paid in the Payment Amoun
payment date in the Payment Date column. The unpaid balance will automatically be reflected as the outstanding balance for th

When the remaining outstanding part of the invoice is subsequently paid, there may not be space to enter the next payment d
was included in a single line. You therefore need to insert a new row below the original invoice row, copy all the data from co
invoice line, replace the value in the Tax Inclusive Amount column with a zero value and enter the new payment amount & date
added. These steps need to be repeated if more than two payments are made for any invoice and there aren't sufficient line
amounts.

Trade Debtors Balances

If you want to view the list of invoices which make up any of the monthly trade debtor balances on the balance sheet, ente
balance date in cell L2 and then use the filter arrow next to the column heading in the outstanding balance column to des
invoices with balances at the appropriate month-end date will then be displayed.

Note: If the total of all the outstanding invoices does not agree to the balance sheet total, make sure that you have entered a
invoices in column A and that there are no blank values in column A. If you leave invoice numbers blank, it may result in ina
calculations if any of the blank entries have not been paid in full.

Sales Tax

The template provides for two sales tax types namely national or federal sales tax and state sales tax. If you only require one
like to delete the second sales tax type, you will be able to do so without affecting the template formulas by simply deleting
(column G) and Sales Tax 2 Amount (column O). All the appropriate sales tax calculations will then only be based on the one sa

Note: You cannot delete both sales tax types. If you do not require any sales tax calculations, you can leave the sales tax 1
delete the sales tax 2 columns indicated above. No sales tax amounts will then be calculated.

Note: No new columns should be added between the Inclusive Amount and Exclusive Amount columns otherwise it will infl
calculations in this template. Also, if you delete the columns for the second sales tax type, the Sales Tax 1 Amount column ma
but this can safely be ignored as it has no effect on the template calculations. If you do not want to see these validation warni
types and just don't select any tax codes in the second sales tax column.

Recording Transactions - Expenses

All expenses and other payment transactions should be recorded on the Expenses sheet. We also recommend entering all
User input is only required in the columns with yellow column headings. All the columns with light blue column headings
automatically copied when adding new transactions to the sheet.

Note: All the columns on the Expenses sheet have been included in an Excel table. This feature is extremely useful when en
because the formulas in the calculated columns (the columns with light blue column headings) are automatically copied when n
table or when data is entered into the first blank row below the table. You can therefore enter a new transaction by simply
column A - the table will then automatically extend to include the new transaction.

Page 14 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

The Expenses sheet contains the following user input columns:

Document Date - enter the supplier invoice date, date of other supporting document or the bank statement date. We've added
to ensure that only valid dates are entered - you therefore need to ensure that you enter dates in accordance with the re
specified in the System Control Panel.
Supplier - enter the name of the supplier. If the Auto Complete feature is enabled, you should be able to accept its suggesti
entering only a few characters. Note that it is important to enter supplier names accurately if you want to use the Filter
transactions for a specific supplier.
Reference - enter a reference for the transaction in this column. For example, this could be the supplier invoice number or a
"Debit Order" or "Bank Statement".
Description - enter a transaction description in this column.
Tax Inclusive Amount - enter the transaction amount inclusive of sales tax. Expenses and payments should be entered as pos
an income or receipt type transaction which is of an expense or payment nature, the transaction can be entered as a negative
a supplier claim which relates to a supplier invoice that has been recorded previously. In most instances, income and receipt tra
recorded on the Income sheet.
Tax 1 Code - this column contains a drop-down list which enables you to select one of the tax codes added to the Setup sh
federal sales tax. The sales tax percentage which is applied to the transaction is determined based on the sales tax code sel
registered for sales tax purposes, all transactions should be recorded by using a sales tax code which has a zero percentage o
tax code is selected, no sales tax will be calculated.
Tax 2 Code - this column contains a drop-down list which enables you to select one of the tax codes added to the Setup sheet
The sales tax percentage which is applied to the transaction is determined based on the sales tax code selected. If your busine
tax purposes, all transactions should be recorded by using a sales tax code which has a zero percentage on the Setup s
selected, no sales tax will be calculated.

Bank Code - this column contains a drop-down list which includes all the bank codes that have been added to the Setup sheet
bank account that will be affected by the particular transaction. Note that it is imperative that a bank code is assigned to each tra
Account Number - the drop-down list in this column contains all the account codes (and descriptions) that have been cr
therefore need to create the appropriate account on the TB sheet before transactions can be allocated to the account. An
selected for every transaction otherwise template imbalances may be encountered.

Payment Date - enter the actual payment date in this column. The date that should be entered in this column should be the d
made to the supplier. The payment date should be left blank if payment has not been made to the supplier - the outstanding ba
trade creditors. Note that the payment date should always be greater than or equal to the document date.

The Expenses sheet contains the following calculated columns:

Outstanding Balance - if an expense has not been paid in full, the outstanding balance will be reflected in this column.
determined based on the balance date that is entered in cell K2 at the top of the sheet. If the balance date contains no value, th
used to determine which invoices are currently outstanding. You can therefore use the balance date input cell to calculate the
any user defined date.

Exclusive Amount - the formula in this column deducts the sales tax amounts from the tax inclusive amount in order to calcula
tax. For accounting purposes, the exclusive amounts are allocated to the income statement, the sales tax amounts are alloc
accounts and the inclusive amounts are allocated to trade creditors or bank (depending on whether the amounts have been paid
Sales Tax 1 Amount - this column contains a formula which calculates the national or federal sales tax amounts based on the
F. Sales tax will only be calculated if a sales tax code has been selected in column F. The calculation is based on the sales tax
Setup sheet.
Sales Tax 2 Amount - this column contains a formula which calculates the state sales tax amounts based on the tax codes se
will only be calculated if a sales tax code has been selected in column G. The calculation is based on the sales tax percen
sheet.
Inclusive Amount - this column is based on the tax inclusive amount which the user enters in column E.

Error Code - this column will contain an error code if there is a problem with the input in any of the previous columns. All the e
in this column should therefore be corrected in order to ensure that all the template calculations remain accurate. Refer to the
instructions for more information about the reasons for an error code and how to resolve it.

Page 15 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

Note: The drop-down lists in the Account Number column contains both the account number and description but only the
selected when allocating transactions. Excel doesn't actually allow the inclusion of two columns in a drop-down list but we have
to provide the account description together with the account number in the drop-down list. The disadvantage of this work aroun
to enter account numbers - you either need to select the account number from the list or copy a similar transaction that yo
column will also contain an error indicator which refers to a data validation error - this is to be expected because of the work
and can safely be ignored.

All the transactions that are entered on the Expenses sheet are automatically updated to the other sheets in this template. It is
transactions are entered according to the guidance outlined in this section of the instructions otherwise it could result in imbalan

Filtering Transactions

All the column headings on this sheet contain a filter selection arrow - this feature indicates that the Filter feature has been
sheet. This Excel feature is very useful when you need to filter the data that forms part of a table based on the filter criteria whi
the selection arrow.

Example: If you only want to display the transactions for a particular invoice or payment month, you can filter the data base
Payment Date column by selecting the appropriate date filter from the filter menu which is displayed after clicking the selecti
filtered data, simply select the "Clear filter" option in the filtered column in order to remove the filter and to display all the transac

Note that the visible row numbers are typically displayed in blue when a filter has been applied to the sheet. New transactions s
filter is active on the sheet - if you see blue row numbers, all filters need to be removed before data is entered in the next blank
may not extend automatically to include the new transaction.

The sheet also contains totals above the column headings for all columns which contain values and which are suitable for
totals. The formulas in these cells result in only the transactions which are visible on the worksheet being included in the calcula
If you therefore print the sheet while a filter is in effect, the totals above the column headings will be calculated accurately and
which have been printed.

Trade Creditors Balances

If you want to view the list of expenses which make up any of the monthly trade creditor balances on the balance sheet, simply
end date as the balance date in cell K2 and then use the filter arrow next to the column heading in the outstanding balance
values. All the expenses with balances at the appropriate month-end date will then be displayed.

Sales Tax

The template provides for two sales tax types namely national or federal sales tax and state sales tax. If you only require one
like to delete the second sales tax type, you will be able to do so without affecting the template formulas by simply deleting
(column G) and Sales Tax 2 Amount (column N). All the appropriate sales tax calculations will then only be based on the one sa

Note: You cannot delete both sales tax types. If you do not require any sales tax calculations, you can leave the sales tax 1
delete the sales tax 2 columns indicated above. No sales tax amounts will then be calculated.

Page 16 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

Note: No new columns should be added between the Inclusive Amount and Exclusive Amount columns otherwise it will infl
calculations in this template. Also, if you delete the columns for the second sales tax type, the Sales Tax 1 Amount column ma
but this can safely be ignored as it has no effect on the template calculations. If you do not want to see these validation warni
types and just don't select any tax codes in the second sales tax column.

Recording Transactions - Transfers between Bank Accounts

When funds are transferred between two bank accounts, both the deposit and withdrawal entries need to be recorded. We
entries on the Expenses sheet. The deposit entry should be recorded by selecting the bank account into which the funds are
transfer amount as a negative value. The withdrawal entry should be recorded by selecting the bank account from which th
entering a positive amount.

All transfers between bank accounts should be allocated to the Cash Transfer Control account (BS-0799). By using this
transfers, you can easily determine when only one of the entries (deposit or withdrawal) has been recorded.

Note: You can check whether the balance of the Cash Transfer Control account is nil by selecting the appropriate month end f
the TB sheet and checking whether the balance for account BS-0799 is nil. If the balance is not nil, the transactions for the
reviewed in order to determine why the allocations to the Cash Transfer Control account do not result in a nil balance.

Note: Petty cash transactions should be treated in the same way as transactions that are processed through a bank account
reimbursements should also be treated as transfers between bank accounts and allocated to the Cash Transfer Control accou
the appropriate bank account and the "deposit" of cash into the petty cash account should therefore be recorded.

Recording Transactions - General Ledger Journal Entries

We recommend that all general ledger journal type entries are also recorded on the Expenses sheet. We have basically created
recording of journal entries so that these transactions will not have any cash effect when recorded incorrectly.

The debit part of the journal entry should be recorded as a positive value and the credit part should be recorded as a negative v
Both entries should be allocated to the JC bank code.

Note: If the debit and credit parts of all journal entries balance to a total of nil, the JC bank account should always have a nil ba
that the JC bank account has a balance, it means that you have made an error in recording some of your journal entries. You
sheet for all transactions with a bank code of JC and filter the document dates for the appropriate month in order to review
particular month.

Error Codes

The following error codes may result from inaccurate input on the Income and Expenses sheets and will be displayed in th
heading of the affected input column will be highlighted in orange:

■ E1 - this error code means that the payment date on the Income or Expenses sheet is before the invoice or document date.
by either amending the appropriate invoice or document date or amending the appropriate payment date.

■ E2 - this error code means that the selected account number on the Income or Expenses sheet is invalid. All the accounts wh
TB sheet will be included in the account number list boxes and the error can therefore be rectified by simply selecting a valid
box. New accounts must be created on the TB sheet before being available for selection.

Page 17 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

■ E3 - this error code means that the selected bank account code is invalid. All the bank account codes which have been creat
included in the bank code list boxes and the error can therefore be rectified by simply selecting a valid bank account code
account codes must be created on the Setup sheet before being available for selection.

Note: Input errors may result in inaccurate template calculations and it is therefore imperative that all errors are resolved
statement, cash flow statement and balance sheet. These errors may in fact also cause the balance sheet not to balance.

Income Statement

All the transactions recorded on the Income and Expenses sheets are automatically updated to the monthly income statemen
sheet. All of these income statement accounts are reflected exclusive of any sales tax which may be applicable to the source tra

The income statement includes 12 monthly periods, an annual total and a column for comparison to a prior year. The period
year which is specified on the Setup sheet. If you want to amend the 12 month reporting period, you only need to change the r
order for the reporting period and all calculations on the IS sheet to be updated.

The default account integration has been set up in such a way that the turnover, operating expenses, staff costs and deprec
groups are the only ones that are integrated on an individual account basis. All other account groups are integrated on a grou
the accounts that are included in the appropriate account groups are included in one total line on the income statement.

Note: You can easily identify a group integration on the income statement, cash flow statement and balance sheet by the key in
the key does not end in a "G" but includes complete account numbers, it means that the appropriate lines are integrated on an i

When an account group is integrated on an individual account basis and you make changes to the account numbers on the
accounts to the account group, you basically also need to make the same changes to the income statement or balance shee
need to update the key in column A if the account numbers have been changed or that you need to insert additional lines
formulas from one of the existing lines and edit the key in column A to reflect the new account number(s).

The same process can be followed if you want to change the integration of an account group from account group reporting
individual account reporting. Additional lines need to be added for all the account numbers that form part of the appropriate ac
all columns on the sheet can be copied from the existing line and the keys in column A then need to be replaced by the full acc
necessary to update the appropriate total or profit line which the account groups forms part of.

Note: If you change the reporting of any account group from group to individual reporting and you do not include all acco
statement, your balance sheet may not balance. It is therefore imperative that you add all individual accounts to the appropriat
to report on an individual account basis. Refer to the TB sheet and more specifically the Status column where all integration erro

Note: If you are not going to use any of the default account groups which have been included on the income statement, we su
of deleting them. If you do decide to delete the rows containing the affected account groups, you may have to fix some of the to
deleting the account groups, you should also delete the individual accounts on the TB sheet linked to the appropriate account g
can be allocated to these groups.

Cash Flow Statement

All the transactions recorded on the Income and Expenses sheets are also automatically updated to the monthly cash flow st
the CFS sheet. No user input is required on this sheet.

Page 18 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

Note: The same principles with regards to account group integration as included in the Income Statement section applies to the
not however recommend changing the default account group integration on this sheet. Most account groups are set to report on
and there is no real benefit in switching to individual account integration on the cash flow statement.

Note: The only changes that may be required are the addition of new lines if you have added any new account groups to the
need to copy a line of a similar nature (which has a green key in column A) and change the key in column A so that the mo
based on the new account group.

Note: All the keys in column A which are reflected in orange contain custom calculations relating to specific control accounts w
any new account group lines.

Balance Sheet

All the transactions recorded on the Income and Expenses sheets are also automatically updated to the monthly balance shee
sheet. No user input is required on this sheet.

The balances sheet account integration is set up to report account group totals for most of the balance sheet items. The exc
accounts in the current assets section which all report individually. If you therefore add additional bank codes to the Setup
additional rows in this section to include the new bank codes in the balance sheet. You only need to insert the required numbe
the formulas from one of the existing bank account lines to complete this process. The formulas will automatically pick up the co

If you want to change the account integration for any line on the balance sheet from group reporting to individual reporting,
required number of additional rows, copy the formulas from the existing line and replace the account group key in column A wit
you do not add all the accounts that form part of the appropriate account group, your balance sheet may not balance.

Note: If you convert one or more account groups from account group reporting to individual account reporting, you may also ne
total column on the balance sheet.

Note: Only the balance sheet items with green account keys can be changed to individual account reporting. The items w
accounts which have unique formulas which cannot be used for any of the other balance sheet items.

Balance Sheet Imbalances

We have included two rows below the balance sheet that contain control totals which indicate whether the balance sheet
indicates whether the balance sheet balances (which means that the total assets equal the total equity & liabilities) and the s
the total of all the bank account balances on the balance sheet agrees to the monthly closing cash balance on the cash flow sta

Both control totals should always display an "ok" text string but if there is a problem with the appropriate control total, a
highlighted in orange will be displayed. This error message means that there is an imbalance in the template and the va
displayed above the error message for balance sheet errors and below the error message for cash flow statement errors.

We recommend completing the following steps when encountering errors:

■ Review the Income and Expenses sheets and ensure that there are no error codes in the Error Code columns. The Error C
should contain no error codes - if an error code is displayed in any transaction row, refer to the Error Codes section of these ins
reason why an error code is displayed and the corrective action that needs to be taken.
■ Review the Income and Expenses sheets and ensure that a bank code has been allocated to all transactions. If there are any
column, select the appropriate bank code from the list box.

Page 19 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

■ Review the Income and Expenses sheets and ensure that a valid account number has been selected for all transactions. If th
Account Number column, select a valid account number from the drop-down list.

■ Review the invoice date, document date and payment date columns on the Income and Expenses sheets and ensure that a
accordance with the regional date settings that are specified in the System Control Panel. A quick way of checking this is to
column as values - all valid dates will then be displayed as values and invalid date entries will still be displayed as text w
reviewing all dates, remember to undo the value formatting otherwise the contents of the affected date column will contain value

■ Open the Setup sheet and ensure that all additional bank accounts have been added to the TB and BS sheets. If a bank ac
these sheets, the status in column D or E will show as "add!". Refer to the Setup - Bank Accounts section of the instructions
bank accounts to the appropriate sheet. Once the bank account has been added, the status will automatically change to "ok".
■ Open the TB sheet and ensure that the template opening balances (column C) add up to a total of nil. If your opening balanc
sheet will also not balance.

■ Review the Status column on the TB sheet and ensure that there are no items highlighted in red. If an item is highlighted
message, it indicates that the appropriate account group has been set to report on an individual account basis and that the high
added to the income statement or balance sheet. If an item is highlighted in red and contains a double error, it means that
integrated on the individual account number basis but that the group integration (ending in a "G") is also still active on the i
sheet. The row with the group integration in the Key column on the income statement or balance sheet therefore needs to be de
■ Review the income statement, cash flow statement and balance sheet and check that there are no duplicate keys in column A
number or group key, the balance sheet will not balance.

If you've completed all of the above steps and still cannot resolve the imbalance on the balance sheet, contact our Support
probably need to send us your version of the template so that we can determine what the cause of the imbalance is.

Bank Account Movement Analysis

We have included the Bank sheet to enable users to analyse bank account movements for any bank account on a daily and
input that is required on this sheet is to select the appropriate bank code and monthly period from the drop-down lists at the top

Note: If you want to display the bank account movement totals for all bank codes, simply clear the contents of the bank code in
is selected, the calculations will default to the last month of the current financial year.

Note: Negative values that have been included on the Expenses sheet are deemed to be Income and therefore includ
Transactions that have been allocated to the JC general journal bank code are not included in the calculations on this sheet.

Sales Tax Analysis

We have also included an additional sheet which enables users to analyse sales tax movements on a monthly basis. The
movement in the sales tax control accounts (BS-1700 and BS-1710) down into individual components which makes it easier to
paid amounts.

The main components of the sales tax control accounts are output tax, input tax and payments. The output tax totals are calcul
Amount columns on the Income sheet, the input tax totals are calculated based on the Sales Tax Amount columns on the Expe
column includes all transactions on the Income and Expenses sheets which have been allocated to account BS-1700 or BS-171

Note: All sales tax payments should be recorded on the Expenses sheet and allocated to the appropriate sales tax contro
refunds should be recorded on the Income sheet and allocated to the sales tax control accounts (BS-1700 for national or fed
state sales tax).

Page 20 of 36
Excel Skills | Basic Accounting Template
Instructions
[Link]

The Inclusive section provides the monthly totals inclusive of sales tax - as per the Income sheet for the Output column and a
the Input column. These totals are usually required when completing sales tax returns.

The net monthly column is calculated by deducting the monthly input tax value from the monthly output tax value and therefor
sales tax liability (or asset if the input exceeds the output). The effective monthly sales tax percentages are also calculated and

Note: You can select the tax type from the list box in cell D2 - options include national / federal sales tax, state sales tax or both
option is assumed and the calculations are reflected for both sales taxes and therefore both sales tax control accounts.

Note: You can also select individual sales tax codes from the list boxes in cell E2 and F2 at the top of the sheet to display the
the tax codes which have been included on the Setup sheet. The content of these list box can then simply be cleared to displa
codes.

Note: The template provides for two sales tax types namely national or federal sales tax and state sales tax. If you only requir
would like to delete the second sales tax type, you will be able to do so without affecting the template formulas by simply de
Code and Sales Tax 2 Amount on the Income and Expenses sheets. All the appropriate sales tax calculations will then only b
type.

Note: You cannot delete both sales tax types. If you do not require any sales tax calculations, you can leave the sales tax 1
sales tax 2 columns as indicated above. No sales tax amounts will then be calculated.

Roll Forward for Subsequent Financial Periods

After specifying the first financial year on the Setup sheet and including the appropriate opening balances in column C on the T
rolled forward for subsequent financial years quite easily. All you need to do in order to roll the template forward for subseque
previous financial years is to amend the reporting year on the Setup sheet.

When you change the reporting year, the monthly reporting periods on all the sheets that are included in the template are a
calculations are automatically updated. You therefore do not need to save a separate version of the template for each financi
adding transactions to the Income and Expenses sheets and use the reporting year setting on the Setup sheet to navigate betw

Help & Customization

If you experience any difficulty while using this template and you are not able to find the appropriate guidance in these inst
support@[Link] for assistance. This template has been designed with flexibility in mind to ensure that it can
environments. If however you need an Excel based template that is customized specifically for your business requirements
function and provide a brief explanation of your requirements.

© Copyright

This template remains the intellectual property of [Link] and is protected by international copyright laws. Any pu
template outside the scope of the permitted use of the template is expressly prohibited. In terms of the permitted use of this tem
the template to persons within the same organisation as the registered user or persons outside the organisation who can reaso
access to the template as a direct result of the use of the template by the registered user is allowed. Subsequent distributio
outside of the organisation is however expressly prohibited and represents an infringement of international copyright laws.

Page 21 of 36
Example (Pty) Limited
Setup
© [Link]
Business Name Example (Pty) Limited

Report Setup
First Day:
First Financial Year * 2025 3/1/2024 * Should be set once when you start using the template
First Day:
Reporting Year ** 2025 3/1/2024 ** Change annually to roll reporting periods forward or back

Year End Month February On this sheet:

Enter your business name and maintain sales tax percentages & bank codes.
Sales Tax You can also add an unlimited number of sales tax codes and bank account
Code Description Percentage codes. Specify the first financial year that you want to include in the template
A Standard Sales Tax 1 15.0% and set your year-end and reporting year. The 12-month reporting period
B Standard Sales Tax 2 0.0% included on the monthly income statement, cash flow statement and balance
C Standard Sales Tax 3 0.0% sheet is determined by the reporting year specified on this sheet which means
E Exempt 0.0% that the template can be rolled forward or back by simply changing the
Z Zero Rated 0.0% reporting year. All the template calculations are then automatically updated.
End of list

Bank Accounts
Code Description TB Status BS Status
B1 B1 Bank Account ok ok
B2 B2 Bank Account ok ok
B3 B3 Bank Account ok ok
PC PC Petty Cash ok ok
JC GL Journal Control ok ok
End of list

Input Error Codes

Code Reason
E1 Payment date is before the invoice / document date
E2 Account number is invalid
E3 Bank code is invalid

January
February
March
April
May
June
July
August
September
October
November
December

Page 22 of 36
Example (Pty) Limited
Account Group Setup
© [Link]
Group
Group Description
Key
BS-00 Property, Plant & Equipment - Cost
BS-01 Property, Plant & Equipment - Accum Dep
BS-02 Intangible Assets - Cost On this sheet:

BS-03 Intangible Assets - Amortization This sheet contains the default list of account groups used in
this template. You can customize the descriptions of the
BS-04 Investments
account groups but we do not recommend changing the
BS-05 Loans & Advances
account group keys. Additional account groups can be added as
BS-07 Cash On Hand
detailed in the template instructions.
BS-09 Other Debtors
BS-13 Accruals
BS-14 Dividends Payable
BS-15 Provision for Taxation
BS-16 Other Provisions
BS-17 Sales Tax
BS-18 Long Term Liabilities
BS-19 Reserves
BS-20 Shareholders' Contributions
IS-01 Income From Services
IS-03 Operating Expenses
IS-04 Staff Costs
IS-05 Depreciation & Amortization
IS-06 Interest Paid
IS-07 Taxation Paid
IS-08 Other Expenses
IS-09 Other Income
IS-10 Dividends Paid

Control Accounts
BS-B Bank Accounts
BS-RC Trade Debtors
BS-PA Trade Creditors
BS-RT Retained Earnings - Opening
BS-IN Retained Earnings - Current

Page 23 of 36
Example (Pty) Limited
Trial Balance & Chart of Accounts 2/29/2024 2/29/2024
© [Link] 29 Feb 2024 29 Feb 2024 28 Feb 2025
Account Template: Trial Balance: Account Trial Balance:
Account Description
Number Opening Balance Opening Balance Movement Closing Balance
BS-0005 Land & Buildings - Cost - - - -
BS-0010 Plant & Equipment - Cost - - - -
BS-0015 Furniture & Fittings - Cost 120,500.00 120,500.00 15,450.00 135,950.00
BS-0020 Office Equipment - Cost 63,250.00 63,250.00 10,200.00 73,450.00
BS-0025 Computer Equipment - Cost - - - -
BS-0030 Other Assets - Cost - - - -
On this sheet:
BS-0105 Land & Buildings - Accum Depreciation - - - -
The opening balance sheet balances should be entered in column C on this sheet. A trial
BS-0110 Plant & Equipment - Accum Depreciation - - - -
balance at the end of the year before the first financial year which is set on the Setup sheet
BS-0115 Furniture & Fittings - Accum Depreciation (22,000.00) (22,000.00) (18,232.00) (40,232.00)
should be used for this purpose. Note that the Bank, Trade Debtors and Trade Creditors
BS-0120 Office Equipment - Accum Depreciation (12,500.00) (12,500.00) (12,190.00) (24,690.00)
opening balances are calculated and therefore need to be included on the Income and
BS-0125 Computer Equipment - Accum Depreciation - - - -
Expenses sheets. The default list of accounts can be customized by adding additional
BS-0130 Other Assets - Accum Depreciation - - - -
accounts to the list, changing the descriptions of existing accounts or deleting accounts. The
BS-0205 Goodwill - Cost - -
sheet also contains a detailed trial balance which can be displayed for any of- the appropriate -
BS-0210 Trademarks - Cost monthly periods by simply selecting - the appropriate month - end at the top of- the sheet. -
BS-0215 Software - Cost 147,200.00 147,200.00 - 147,200.00
BS-0305 Goodwill - Accum Amortization - - - -
BS-0310 Trademarks - Accum Amortization - - - -
BS-0315 Software - Accum Amortization (29,440.00) (29,440.00) (14,720.00) (44,160.00)
BS-0400 Investments 150,000.00 150,000.00 30,750.00 180,750.00
BS-0500 Loans & Advances 12,000.00 12,000.00 (12,000.00) -
BS-0700 Cash On Hand - - - -
BS-0799 Cash Transfer Control - - - -
BS-0900 Other Debtors - - - -
BS-0905 Prepayments 15,000.00 15,000.00 (15,000.00) -
BS-1300 Accruals - - - -
BS-1305 Payroll Accruals - - - -
BS-1310 Interest Payable - - - -
BS-1405 Dividends Payable - - (50,000.00) (50,000.00)
BS-1505 Provision For Taxation - - - -
BS-1610 Provision For Bonuses - - - -
BS-1700 Sales Tax 1 - National / Federal (20,240.00) (20,240.00) 3,121.35 (17,118.65)
BS-1710 Sales Tax 2 - State - - - -
BS-1805 Long Term Loans (200,000.00) (200,000.00) (16,249.61) (216,249.61)
BS-1900 Reserves - - - -
BS-2000 Shareholders' Contributions (100.00) (100.00) - (100.00)
IS-0105 Software Sales - (1,720,236.39) (1,720,236.39)
IS-0110 Advertising Income - (196,920.00) (196,920.00)
IS-0115 Commission Received - (22,326.96) (22,326.96)
IS-0305 Accounting Fees - 23,982.61 23,982.61
IS-0310 Advertising & Marketing - 143,643.00 143,643.00
IS-0315 Bank Charges - 1,179.30 1,179.30
IS-0320 Commission - 27,850.00 27,850.00
IS-0325 Computer Expenses - 3,476.52 3,476.52
IS-0330 Consumables & Cleaning - 2,500.00 2,500.00
IS-0335 Entertainment - - -
IS-0340 Insurance - 3,837.22 3,837.22
IS-0345 Office Expenses - 995.65 995.65
IS-0350 Office Rent - 143,895.65 143,895.65
IS-0355 Postage - 520.00 520.00
IS-0360 Professional & Legal Fees - 5,652.17 5,652.17
IS-0365 Stationery - 2,491.30 2,491.30
IS-0370 Subscriptions & Memberships - 5,200.00 5,200.00
IS-0375 Telephone & Internet - 8,860.87 8,860.87
IS-0380 Training - 4,043.48 4,043.48
IS-0385 Travelling & Accommodation - 13,704.35 13,704.35
IS-0390 Utilities - - -
IS-0405 Salaries & Wages - Staff - 548,600.00 548,600.00
IS-0410 Salaries & Wages - Management - 685,720.00 685,720.00
IS-0505 Depreciation - 30,422.00 30,422.00
IS-0510 Amortization - 14,720.00 14,720.00
IS-0600 Interest Paid - 19,367.24 19,367.24
IS-0700 Taxation - 70,765.00 70,765.00
IS-0800 Other Expenses - - -
IS-0805 Foreign Exchange Loss - - -
IS-0810 Loss on Disposal of Assets - - -
IS-0900 Other Income - (1,929.85) (1,929.85)
IS-1000 Dividends - 50,000.00 50,000.00
End of list - add accounts above this row

Control Accounts
BS-BB1 B1 Bank Account 45,250.50 45,250.50 295,326.44 340,576.94
BS-BB2 B2 Bank Account 61,500.00 61,500.00 (26,719.35) 34,780.65
BS-BB3 B3 Bank Account - - 9,457.00 9,457.00
BS-BPC PC Petty Cash 1,000.00 1,000.00 (5.00) 995.00
BS-BJC GL Journal Control - - - -
BS-RCG Trade Debtors 146,376.00 146,376.00 (53,316.00) 93,060.00
BS-PAG Trade Creditors (45,153.00) (45,153.00) (15,886.00) (61,039.00)
BS-RTG Retained Earnings (432,643.50) (432,643.50) - (432,643.50)

- - - -

Page 24 of 36
Example (Pty) Limited Balance Date
Income & Other Receipts 2/28/2025 2/28/2025
© [Link] 2,503,207.95 2,471,297.95 93,060.00 2,226,447.18 276,760.77 - 2,503,207.95
Invoice Tax Inclusive Tax 1 Tax 2 Bank Account Payment Outstanding Exclusive Sales Tax 1 Sales Tax 2 Unique Error
Number Invoice Date Customer Description Amount Code Code Code Number Payment Amount Date Balance Amount Amount Amount Inclusive Amount INV Code
IN0051 2/10/2024 DF Manufacturing Software Sales 35,796.00 A E B1 BS-0799 35,796.00 3/1/2024 - 31,126.96 4,669.04 - 35,796.00 Y -
IN0052 2/18/2024 CC Supplies Software Sales 110,580.00 A E B1 BS-0799 110,580.00 3/10/2024 - 96,156.52 14,423.48 - 110,580.00 Y -
OB 2/28/2024 Opening Balance Opening Bank Balance 45,250.50 E E B1 BS-0799 45,250.50 2/28/2024 - 45,250.50 - - 45,250.50 Y -
OB 2/28/2024 Opening Balance Opening Bank Balance 61,500.00 E E B2 BS-0799 61,500.00 2/28/2024 - 61,500.00 - - 61,500.00 N -
OB 2/28/2024 Opening Balance Opening Bank Balance - E E B3 BS-0799 - 2/28/2024 - - - - - N -
OB 2/28/2024 Opening Balance Opening Bank Balance 1,000.00 E E PC BS-0799 1,000.00 2/28/2024 - 1,000.00 - - 1,000.00 N -
On this sheet:
REC0020 3/1/2024 ABC Bank Interest Received 150.01 E E B2 IS-0900 150.01 3/1/2024 - 150.01 - - 150.01 Y -
Record all sales transactions and cash receipts in the columns with yellow column headings
REC0021 3/7/2024 ERP Software Commission Received 1,710.00 A E B1 IS-0115 1,710.00 3/7/2024 - 1,486.96 223.04 - 1,710.00 Y -
on this sheet. The columns with light blue column headings contain formulas which are
IN0053 3/14/2024 IT Solutions Software Sales 12,880.00 E E B1 IS-0105 12,880.00 4/13/2024 - 12,880.00 - - 12,880.00 Y -
automatically copied for all new transactions added to the table. All income transactions are
IN0054 3/19/2024 IQ Bonds Software Sales 125,018.10 A E B1 IS-0105 125,018.10 4/10/2024 - 108,711.39 16,306.71 - 125,018.10 Y -
included in trade debtors & income based on the invoice dates entered in column B. When
REC0022 an 3/25/2024
invoice isGoogle
paid byAdSense
the customer, simply Advertising
enterIncome
the payment amount & 12,500.00 E
payment date and E B2 IS-0110 12,500.00 4/5/2024 - 12,500.00 - - 12,500.00 Y -
REC0023 the4/1/2024 ABC amount
transaction Bank is automatically Interest Receivedfrom trade debtors and
removed 120.65 E in the
included E B2 IS-0900 120.65 4/1/2024 - 120.65 - - 120.65 Y -
REC0024 4/7/2024
appropriate ERP
bankSoftware
balance. Sales taxCommission
codes, bankReceived
codes and account 1,380.00
numbers Acan be E B1 IS-0115 1,380.00 4/7/2024 - 1,200.00 180.00 - 1,380.00 Y -
IN0055 4/9/2024
selected from WC Financial
the Advisorslists in the
drop-down Software Sales
appropriate 137,482.50
columns. Outstanding balancesA can be E B1 IS-0105 137,482.50 5/9/2024 - 119,550.00 17,932.50 - 137,482.50 Y -
IN0056 4/22/2024by DF
displayed Manufacturing
simply entering the appropriateSoftwarebalance
Sales date at the top of 20,033.00
the sheet. A E B1 IS-0105 20,033.00 5/9/2024 - 17,420.00 2,613.00 - 20,033.00 Y -
REC0025 4/25/2024 Google AdSense Advertising Income 10,300.00 E E B2 IS-0110 10,300.00 5/5/2024 - 10,300.00 - - 10,300.00 Y -
REC0026 5/1/2024 ABC Bank Interest Received 160.23 E E B2 IS-0900 160.23 5/1/2024 - 160.23 - - 160.23 Y -
IN0057 5/5/2024 GP Accountants Software Sales 106,950.00 A E B1 IS-0105 106,950.00 5/10/2024 - 93,000.00 13,950.00 - 106,950.00 Y -
IN0058 5/7/2024 Energy Incorporated Software Sales 9,464.50 A E B1 IS-0105 9,464.50 6/6/2024 - 8,230.00 1,234.50 - 9,464.50 Y -
REC0027 5/7/2024 ERP Software Commission Received 1,610.00 A E B1 IS-0115 1,610.00 5/7/2024 - 1,400.00 210.00 - 1,610.00 Y -
IN0059 5/10/2024 Energy Incorporated Software Sales 26,220.00 A E B1 IS-0105 26,220.00 6/9/2024 - 22,800.00 3,420.00 - 26,220.00 Y -
REC0028 5/25/2024 Google AdSense Advertising Income 15,200.00 E E B2 IS-0110 15,200.00 6/5/2024 - 15,200.00 - - 15,200.00 Y -
IN0060 5/31/2024 CC Supplies Software Sales 67,907.50 A E B1 IS-0105 67,907.50 6/30/2024 - 59,050.00 8,857.50 - 67,907.50 Y -
REC0029 6/1/2024 ABC Bank Interest Received 170.21 E E B2 IS-0900 170.21 6/1/2024 - 170.21 - - 170.21 Y -
REC0030 6/7/2024 ERP Software Commission Received 1,840.00 A E B1 IS-0115 1,840.00 6/7/2024 - 1,600.00 240.00 - 1,840.00 Y -
REC0031 6/25/2024 Google AdSense Advertising Income 9,500.00 E E B2 IS-0110 9,500.00 7/5/2024 - 9,500.00 - - 9,500.00 Y -
IN0061 6/26/2024 DF Manufacturing Software Sales 154,100.00 A E B1 IS-0105 154,100.00 7/26/2024 - 134,000.00 20,100.00 - 154,100.00 Y -
IN0062 6/29/2024 WC Financial Advisors Software Sales 14,421.00 A E B1 IS-0105 14,421.00 7/16/2024 - 12,540.00 1,881.00 - 14,421.00 Y -
REC0032 7/1/2024 ABC Bank Interest Received 165.23 E E B2 IS-0900 165.23 7/1/2024 - 165.23 - - 165.23 Y -
REC0033 7/7/2024 ERP Software Commission Received 2,415.00 A E B1 IS-0115 2,415.00 7/7/2024 - 2,100.00 315.00 - 2,415.00 Y -
IN0063 7/11/2024 PTY Consultants Software Sales 135,700.00 A E B1 IS-0105 135,700.00 7/16/2024 - 118,000.00 17,700.00 - 135,700.00 Y -
IN0064 7/22/2024 WW Retail Software Sales 17,480.00 A E B1 IS-0105 17,480.00 8/21/2024 - 15,200.00 2,280.00 - 17,480.00 Y -
REC0034 7/25/2024 Google AdSense Advertising Income 22,300.00 E E B2 IS-0110 22,300.00 8/5/2024 - 22,300.00 - - 22,300.00 Y -
REC0035 8/1/2024 ABC Bank Interest Received 166.24 E E B2 IS-0900 166.24 8/1/2024 - 166.24 - - 166.24 Y -
REC0036 8/7/2024 ERP Software Commission Received 2,185.00 A E B1 IS-0115 2,185.00 8/7/2024 - 1,900.00 285.00 - 2,185.00 Y -
IN0065 8/13/2024 EC Estate Agents Software Sales 132,250.00 A E B1 IS-0105 132,250.00 9/12/2024 - 115,000.00 17,250.00 - 132,250.00 Y -
IN0066 8/17/2024 The Paint Shop Software Sales 14,915.50 A E B1 IS-0105 14,915.50 9/16/2024 - 12,970.00 1,945.50 - 14,915.50 Y -
REC0037 8/25/2024 Google AdSense Advertising Income 21,400.00 E E B2 IS-0110 21,400.00 9/5/2024 - 21,400.00 - - 21,400.00 Y -
REC0038 9/1/2024 ABC Bank Interest Received 164.21 E E B2 IS-0900 164.21 9/1/2024 - 164.21 - - 164.21 Y -
REC0039 9/7/2024 ERP Software Commission Received 2,070.00 A E B1 IS-0115 2,070.00 9/7/2024 - 1,800.00 270.00 - 2,070.00 Y -
IN0067 9/12/2024 Energy Incorporated Software Sales 55,200.00 A E B1 IS-0105 55,200.00 9/30/2024 - 48,000.00 7,200.00 - 55,200.00 Y -
IN0068 9/17/2024 TRF Solutions Software Sales 130,180.00 A E B1 IS-0105 130,180.00 10/4/2024 - 113,200.00 16,980.00 - 130,180.00 Y -
REC0040 9/25/2024 Google AdSense Advertising Income 15,100.00 E E B2 IS-0110 15,100.00 10/5/2024 - 15,100.00 - - 15,100.00 Y -
REC0041 10/1/2024 ABC Bank Interest Received 165.89 E E B2 IS-0900 165.89 10/1/2024 - 165.89 - - 165.89 Y -
REC0042 10/7/2024 ERP Software Commission Received 2,530.00 A E B1 IS-0115 2,530.00 10/7/2024 - 2,200.00 330.00 - 2,530.00 Y -
IN0069 10/8/2024 EC Estate Agents Software Sales 25,564.50 A E B1 IS-0105 25,564.50 10/13/2024 - 22,230.00 3,334.50 - 25,564.50 Y -
IN0070 10/8/2024 GP Accountants Software Sales 33,120.00 A E B1 IS-0105 33,120.00 10/13/2024 - 28,800.00 4,320.00 - 33,120.00 Y -
REC0043 10/25/2024 Google AdSense Advertising Income 18,400.00 E E B2 IS-0110 18,400.00 11/5/2024 - 18,400.00 - - 18,400.00 Y -
IN0071 10/31/2024 The Paint Shop Software Sales 144,325.00 A E B1 IS-0105 72,000.00 11/30/2024 - 125,500.00 18,825.00 - 144,325.00 Y -
IN0071 10/31/2024 The Paint Shop Software Sales - A E B1 IS-0105 72,325.00 1/10/2025 - - - - - N -
REC0044 11/1/2024 ABC Bank Interest Received 167.25 E E B2 IS-0900 167.25 11/1/2024 - 167.25 - - 167.25 Y -
IN0072 11/3/2024 PTY Consultants Software Sales 3,588.00 A E B1 IS-0105 3,588.00 12/3/2024 (0.00) 3,120.00 468.00 - 3,588.00 Y -
REC0045 11/7/2024 ERP Software Commission Received 2,760.00 A E B1 IS-0115 2,760.00 11/7/2024 - 2,400.00 360.00 - 2,760.00 Y -
REC0046 11/25/2024 Google AdSense Advertising Income 22,150.00 E E B2 IS-0110 22,150.00 12/5/2024 - 22,150.00 - - 22,150.00 Y -
IN0073 11/29/2024 CC Supplies Software Sales 15,180.00 A E B1 IS-0105 15,180.00 12/21/2024 (0.00) 13,200.00 1,980.00 - 15,180.00 Y -
IN0074 11/29/2024 XX Building Supplies Software Sales 132,250.00 A E B1 IS-0105 132,250.00 12/29/2024 - 115,000.00 17,250.00 - 132,250.00 Y -
REC0047 12/1/2024 ABC Bank Interest Received 166.45 E E B2 IS-0900 166.45 12/1/2024 - 166.45 - - 166.45 Y -
REC0048 12/7/2024 ERP Software Commission Received 1,771.00 A E B1 IS-0115 1,771.00 12/7/2024 - 1,540.00 231.00 - 1,771.00 Y -
IN0075 12/12/2024 Energy Incorporated Software Sales 115,000.00 A E B1 IS-0105 115,000.00 1/2/2025 - 100,000.00 15,000.00 - 115,000.00 Y -
IN0076 12/25/2024 IT Solutions Software Sales 13,045.00 E E B1 IS-0105 13,045.00 1/11/2025 - 13,045.00 - - 13,045.00 Y -
REC0049 12/25/2024 Google AdSense Advertising Income 10,320.00 E E B2 IS-0110 10,320.00 1/5/2025 - 10,320.00 - - 10,320.00 Y -
REC0050 1/1/2025 ABC Bank Interest Received 166.23 E E B2 IS-0900 166.23 1/1/2025 - 166.23 - - 166.23 Y -
CN0011 1/5/2025 IT Solutions Module Discount (1,150.00) E E B1 IS-0105 (1,150.00) 1/11/2025 - (1,150.00) - - (1,150.00) Y -
REC0051 1/7/2025 ERP Software Commission Received 2,300.00 A E B1 IS-0115 2,300.00 1/7/2025 - 2,000.00 300.00 - 2,300.00 Y -
REC0050 1/10/2025 ABC Bank Loan Received 50,000.00 E E B2 BS-1805 50,000.00 1/10/2025 - 50,000.00 - - 50,000.00 N -
IN0077 1/19/2025 PTY Consultants Software Sales 16,606.00 A E B1 IS-0105 16,606.00 1/31/2025 - 14,440.00 2,166.00 - 16,606.00 Y -

Page 25 of 36
Example (Pty) Limited Balance Date
Income & Other Receipts 2/28/2025 2/28/2025
© [Link] 2,503,207.95 2,471,297.95 93,060.00 2,226,447.18 276,760.77 - 2,503,207.95
Invoice Tax Inclusive Tax 1 Tax 2 Bank Account Payment Outstanding Exclusive Sales Tax 1 Sales Tax 2 Unique Error
Number Invoice Date Customer Description Amount Code Code Code Number Payment Amount Date Balance Amount Amount Amount Inclusive Amount INV Code
IN0078 1/20/2025 GP Accountants Software Sales 141,910.00 A E B1 IS-0105 110,000.00 2/26/2025 31,910.00 123,400.00 18,510.00 - 141,910.00 Y -
IN0078 1/20/2025 GP Accountants Software Sales - A E B1 IS-0105 - - - - - N -
REC0052 1/25/2025 Google AdSense Advertising Income 15,400.00 E E B2 IS-0110 15,400.00 2/5/2025 - 15,400.00 - - 15,400.00 Y -
REC0053 2/1/2025 ABC Bank Interest Received 167.25 E E B2 IS-0900 167.25 2/1/2025 - 167.25 - - 167.25 Y -
REC0054 2/7/2025 ERP Software Commission Received 3,105.00 A E B1 IS-0115 3,105.00 2/7/2025 - 2,700.00 405.00 - 3,105.00 Y -
IN0079 2/15/2025 WC Financial Advisors Software Sales 120,865.00 A E B1 IS-0105 138,115.00 2/28/2025 - 105,100.00 15,765.00 - 120,865.00 Y -
IN0079 2/15/2025 WC Financial Advisors Additional Module 17,250.00 A E B1 IS-0105 - 2/28/2025 - 15,000.00 2,250.00 - 17,250.00 N -
REC0055 2/25/2025 Google AdSense Advertising Income 24,350.00 E E B2 IS-0110 24,350.00 24,350.00 24,350.00 - - 24,350.00 Y -
IN0080 2/28/2025 XX Building Supplies Software Sales 36,800.00 A E B1 IS-0105 36,800.00 36,800.00 32,000.00 4,800.00 - 36,800.00 Y -

Page 26 of 36
Example (Pty) Limited Balance Date
Expenses & Other Payments 2/28/2025 2/28/2025
© [Link] 2,085,377.36 61,039.00 2,038,411.97 46,965.39 - 2,085,377.36
Document Tax Inclusive Tax 1 Tax 2 Bank Account Payment Outstanding Exclusive Sales Tax 1 Sales Tax 2 Error
Date Supplier Reference Description Amount Code Code Code Number Date Balance Amount Amount Amount Inclusive Amount Code
2/14/2024 XY Solutions S77782 Opening Balance 40,365.00 A E B1 BS-0799 3/2/2024 - 35,100.00 5,265.00 - 40,365.00 -
2/17/2024 XY Traders Invoice 13432 Commission 4,788.00 A E B1 BS-0799 3/20/2024 - 4,163.48 624.52 - 4,788.00 -
3/1/2024 IS Communications Invoice EXP22 Internet Service Provider 840.00 A E B1 IS-0375 3/31/2024 - 730.43 109.57 - 840.00 -
3/2/2024 Newscorp I381119 Subscriptions 478.00 A E B1 IS-0355 4/1/2024 - 415.65 62.35 - 478.00 -
3/5/2024 EAG Brokers Debit Order Insurance 364.80 A E B1 IS-0340 3/5/2024 - 317.22 47.58 - 364.80 -
3/15/2024 Capital Bank Bank Statement Service Fees
On this sheet: 57.00 A E B1 IS-0315 3/15/2024 - 49.57 7.43 - 57.00 -
3/15/2024 Record all expense transactions
Capital Bank Bank StatementandService
cash payments
Fees in the columns with yellow
34.20 column
A E B2 IS-0315 3/15/2024 - 29.74 4.46 - 34.20 -
3/15/2024 headings on this sheet.
IAS Accountants The columnsMonthly
Invoice with light blue column headings contain
Accounting 2,280.00 formulas
A E B1 IS-0305 4/2/2024 - 1,982.61 297.39 - 2,280.00 -
3/15/2024 which are automatically
Interflora Cash copied for all new transactions added to the table.
Flowers All expense
90.00 A E PC IS-0345 3/15/2024 - 78.26 11.74 - 90.00 -
3/18/2024 transactions
QQ International are included
TR6998 in trade creditors
Parking & expenses based on the document120.00 dates
A E B1 IS-0385 3/18/2024 - 104.35 15.65 - 120.00 -
3/20/2024 that are (Pty)
Example entered
Ltd in column
Transfer A. When Inter
an expense is paid, simply enter (15,000.00)
Account Transfer the payment Edate E B2 BS-0799 3/20/2024 - (15,000.00) - - (15,000.00) -
3/20/2024 and the transaction
Example (Pty) Ltd amount
Transfer is automatically removed
Inter Account Transferfrom trade creditors and deducted
15,000.00 E E B1 BS-0799 3/20/2024 - 15,000.00 - - 15,000.00 -
3/26/2024 from the(Pty)
Example appropriate
Ltd bank balance. Salaries
Payroll Sales tax codes, bank codes and 45,000.00
account numbers
E E B2 IS-0410 3/26/2024 - 45,000.00 - - 45,000.00 -
3/26/2024 can be
HP Financeselected from the drop-down
Debit Order lists in the
Capital repayment appropriate columns. Outstanding
2,582.74 E E B1 BS-1805 3/26/2024 - 2,582.74 - - 2,582.74 -
3/26/2024
balances
HP Finance
can be displayed by
Debit Order
simply entering
Interest paid
the appropriate balance date at
1,666.67
the top
E
of E B1 IS-0600 3/26/2024 - 1,666.67 - - 1,666.67 -
the sheet.
3/26/2024 PR Properties Debit Order Rent 13,680.00 A E B1 IS-0350 3/26/2024 - 11,895.65 1,784.35 - 13,680.00 -
3/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 3/26/2024 - 35,000.00 - - 35,000.00 -
3/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 4/6/2024 - 7,200.00 - - 7,200.00 -
3/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 4/6/2024 - 9,320.00 - - 9,320.00 -
3/26/2024 Example (Pty) Ltd Payroll Staff Loan Deduction (12,000.00) E E B2 BS-0500 3/26/2024 - (12,000.00) - - (12,000.00) -
3/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 90.00 E E B1 BS-0799 3/31/2024 - 90.00 - - 90.00 -
3/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (90.00) E E PC BS-0799 3/31/2024 - (90.00) - - (90.00) -
3/31/2024 Google Card Online Marketing 10,000.00 E E B3 IS-0310 4/7/2024 - 10,000.00 - - 10,000.00 -
4/1/2024 IS Communications Invoice EXP23 Internet Service Provider 850.00 A E B1 IS-0375 5/1/2024 - 739.13 110.87 - 850.00 -
4/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 4/5/2024 - 320.00 48.00 - 368.00 -
4/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 4/5/2024 - (10,000.00) - - (10,000.00) -
4/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 4/5/2024 - 10,000.00 - - 10,000.00 -
4/12/2024 Interflora Cash Flowers 87.00 A E PC IS-0345 4/12/2024 - 75.65 11.35 - 87.00 -
4/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 4/15/2024 - 69.57 10.43 - 80.00 -
4/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 4/15/2024 - 30.43 4.57 - 35.00 -
4/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 5/3/2024 - 2,000.00 300.00 - 2,300.00 -
4/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (80,000.00) E E B2 BS-0799 4/20/2024 - (80,000.00) - - (80,000.00) -
4/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 80,000.00 E E B1 BS-0799 4/20/2024 - 80,000.00 - - 80,000.00 -
4/25/2024 Inland Revenue Return Sales Tax 34,429.23 E E B1 BS-1700 4/25/2024 - 34,429.23 - - 34,429.23 -
4/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 4/26/2024 - 45,000.00 - - 45,000.00 -
4/26/2024 Furniture City Invoice Furniture 17,767.50 A E B1 BS-0015 5/26/2024 - 15,450.00 2,317.50 - 17,767.50 -
4/26/2024 HP Finance Debit Order Capital repayment 2,604.27 E E B1 BS-1805 4/26/2024 - 2,604.27 - - 2,604.27 -
4/26/2024 HP Finance Debit Order Interest paid 1,645.14 E E B1 IS-0600 4/26/2024 - 1,645.14 - - 1,645.14 -
4/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 4/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
4/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 4/26/2024 - 35,000.00 - - 35,000.00 -
4/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 5/6/2024 - 7,200.00 - - 7,200.00 -
4/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 5/6/2024 - 9,320.00 - - 9,320.00 -
4/29/2024 GF Supplies IN1179 Consumables 2,500.00 A E PC IS-0325 4/29/2024 - 2,173.91 326.09 - 2,500.00 -
4/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 2,587.00 E E B1 BS-0799 4/30/2024 - 2,587.00 - - 2,587.00 -
4/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (2,587.00) E E PC BS-0799 4/30/2024 - (2,587.00) - - (2,587.00) -
4/30/2024 Google Card Online Marketing 9,800.00 E E B3 IS-0310 5/7/2024 - 9,800.00 - - 9,800.00 -
4/30/2024 None Journal Release Prepayment 15,000.00 E E JC IS-0310 4/30/2024 - 15,000.00 - - 15,000.00 -
4/30/2024 None Journal Release Prepayment (15,000.00) E E JC BS-0905 4/30/2024 - (15,000.00) - - (15,000.00) -
5/1/2024 IS Communications Invoice EXP24 Internet Service Provider 850.00 A E B1 IS-0375 5/31/2024 - 739.13 110.87 - 850.00 -
5/1/2024 Training Inc Invoice Course 1,250.00 A E B1 IS-0380 5/31/2024 - 1,086.96 163.04 - 1,250.00 -
5/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 5/5/2024 - 320.00 48.00 - 368.00 -
5/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (15,000.00) E E B3 BS-0799 5/5/2024 - (15,000.00) - - (15,000.00) -
5/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 15,000.00 E E B1 BS-0799 5/5/2024 - 15,000.00 - - 15,000.00 -
5/7/2024 City Lodge S50037 Accommodation 990.00 A E B1 IS-0385 5/7/2024 - 860.87 129.13 - 990.00 -
5/7/2024 Waltons Invoice Stationery 982.00 A E B1 IS-0365 6/6/2024 - 853.91 128.09 - 982.00 -
5/13/2024 XY Traders Invoice 9987 Commission 5,750.00 A E B1 IS-0320 6/12/2024 - 5,000.00 750.00 - 5,750.00 -
5/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 5/15/2024 - 69.57 10.43 - 80.00 -
5/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 5/15/2024 - 30.43 4.57 - 35.00 -
5/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 6/2/2024 - 2,000.00 300.00 - 2,300.00 -

Page 27 of 36
Example (Pty) Limited Balance Date
Expenses & Other Payments 2/28/2025 2/28/2025
© [Link] 2,085,377.36 61,039.00 2,038,411.97 46,965.39 - 2,085,377.36
Document Tax Inclusive Tax 1 Tax 2 Bank Account Payment Outstanding Exclusive Sales Tax 1 Sales Tax 2 Error
Date Supplier Reference Description Amount Code Code Code Number Date Balance Amount Amount Amount Inclusive Amount Code
5/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (100,000.00) E E B2 BS-0799 5/20/2024 - (100,000.00) - - (100,000.00) -
5/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 100,000.00 E E B1 BS-0799 5/20/2024 - 100,000.00 - - 100,000.00 -
5/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 5/26/2024 - 45,000.00 - - 45,000.00 -
5/26/2024 HP Finance Debit Order Capital repayment 2,625.97 E E B1 BS-1805 5/26/2024 - 2,625.97 - - 2,625.97 -
5/26/2024 HP Finance Debit Order Interest paid 1,623.44 E E B1 IS-0600 5/26/2024 - 1,623.44 - - 1,623.44 -
5/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 5/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
5/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 5/26/2024 - 35,000.00 - - 35,000.00 -
5/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 6/6/2024 - 7,200.00 - - 7,200.00 -
5/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 6/6/2024 - 9,320.00 - - 9,320.00 -
5/29/2024 Interflora Cash Flowers 65.00 A E PC IS-0345 5/29/2024 - 56.52 8.48 - 65.00 -
5/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 65.00 E E B1 BS-0799 5/31/2024 - 65.00 - - 65.00 -
5/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (65.00) E E PC BS-0799 5/31/2024 - (65.00) - - (65.00) -
5/31/2024 Google Card Online Marketing 11,020.00 E E B3 IS-0310 6/7/2024 - 11,020.00 - - 11,020.00 -
6/1/2024 IS Communications Invoice EXP25 Internet Service Provider 850.00 A E B1 IS-0375 7/1/2024 - 739.13 110.87 - 850.00 -
6/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 6/5/2024 - 320.00 48.00 - 368.00 -
6/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 6/5/2024 - (10,000.00) - - (10,000.00) -
6/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 6/5/2024 - 10,000.00 - - 10,000.00 -
6/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 6/15/2024 - 69.57 10.43 - 80.00 -
6/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 6/15/2024 - 30.43 4.57 - 35.00 -
6/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 7/3/2024 - 2,000.00 300.00 - 2,300.00 -
6/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (80,000.00) E E B2 BS-0799 6/20/2024 - (80,000.00) - - (80,000.00) -
6/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 80,000.00 E E B1 BS-0799 6/20/2024 - 80,000.00 - - 80,000.00 -
6/22/2024 Interflora Cash Flowers 110.00 A E PC IS-0345 6/22/2024 - 95.65 14.35 - 110.00 -
6/25/2024 Inland Revenue Return Sales Tax 40,016.09 E E B1 BS-1700 6/25/2024 - 40,016.09 - - 40,016.09 -
6/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 6/26/2024 - 45,000.00 - - 45,000.00 -
6/26/2024 HP Finance Debit Order Capital repayment 2,647.85 E E B1 BS-1805 6/26/2024 - 2,647.85 - - 2,647.85 -
6/26/2024 HP Finance Debit Order Interest paid 1,601.56 E E B1 IS-0600 6/26/2024 - 1,601.56 - - 1,601.56 -
6/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 6/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
6/26/2024 SA Airlines SA11235 Travel 2,100.00 A E B1 IS-0385 6/26/2024 - 1,826.09 273.91 - 2,100.00 -
6/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 6/26/2024 - 35,000.00 - - 35,000.00 -
6/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 7/6/2024 - 7,200.00 - - 7,200.00 -
6/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 7/6/2024 - 9,320.00 - - 9,320.00 -
6/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E E B1 BS-0799 6/30/2024 - 100.00 - - 100.00 -
6/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (100.00) E E PC BS-0799 6/30/2024 - (100.00) - - (100.00) -
6/30/2024 Google Card Online Marketing 10,500.00 E E B3 IS-0310 7/7/2024 - 10,500.00 - - 10,500.00 -
7/1/2024 IS Communications Invoice EXP26 Internet Service Provider 850.00 A E B1 IS-0375 7/31/2024 - 739.13 110.87 - 850.00 -
7/2/2024 Waltons Invoice Stationery 761.00 A E B1 IS-0365 8/1/2024 - 661.74 99.26 - 761.00 -
7/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 7/5/2024 - 320.00 48.00 - 368.00 -
7/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 7/5/2024 - (10,000.00) - - (10,000.00) -
7/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 7/5/2024 - 10,000.00 - - 10,000.00 -
7/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 7/15/2024 - 69.57 10.43 - 80.00 -
7/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 7/15/2024 - 30.43 4.57 - 35.00 -
7/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 8/2/2024 - 2,000.00 300.00 - 2,300.00 -
7/16/2024 Interflora Cash Flowers 29.00 A E PC IS-0345 7/16/2024 - 25.22 3.78 - 29.00 -
7/17/2024 GF Supplies IN1181 Consumables 2,875.00 A E B1 IS-0330 8/16/2024 - 2,500.00 375.00 - 2,875.00 -
7/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (100,000.00) E E B2 BS-0799 7/20/2024 - (100,000.00) - - (100,000.00) -
7/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 100,000.00 E E B1 BS-0799 7/20/2024 - 100,000.00 - - 100,000.00 -
7/25/2024 ACC Institute M00321037 Annual Membership 5,980.00 A E B1 IS-0370 8/24/2024 - 5,200.00 780.00 - 5,980.00 -
7/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 7/26/2024 - 45,000.00 - - 45,000.00 -
7/26/2024 HP Finance Debit Order Capital repayment 2,669.92 E E B1 BS-1805 7/26/2024 - 2,669.92 - - 2,669.92 -
7/26/2024 HP Finance Debit Order Interest paid 1,579.49 E E B1 IS-0600 7/26/2024 - 1,579.49 - - 1,579.49 -
7/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 7/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
7/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 7/26/2024 - 35,000.00 - - 35,000.00 -
7/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 8/6/2024 - 7,200.00 - - 7,200.00 -
7/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 8/6/2024 - 9,320.00 - - 9,320.00 -
7/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 29.00 E E B1 BS-0799 7/31/2024 - 29.00 - - 29.00 -
7/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (29.00) E E PC BS-0799 7/31/2024 - (29.00) - - (29.00) -
7/31/2024 Google Card Online Marketing 10,850.00 E E B3 IS-0310 8/7/2024 - 10,850.00 - - 10,850.00 -
8/1/2024 IS Communications Invoice EXP27 Internet Service Provider 850.00 A E B1 IS-0375 8/31/2024 - 739.13 110.87 - 850.00 -

Page 28 of 36
Example (Pty) Limited Balance Date
Expenses & Other Payments 2/28/2025 2/28/2025
© [Link] 2,085,377.36 61,039.00 2,038,411.97 46,965.39 - 2,085,377.36
Document Tax Inclusive Tax 1 Tax 2 Bank Account Payment Outstanding Exclusive Sales Tax 1 Sales Tax 2 Error
Date Supplier Reference Description Amount Code Code Code Number Date Balance Amount Amount Amount Inclusive Amount Code
8/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 8/5/2024 - 320.00 48.00 - 368.00 -
8/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 8/5/2024 - (10,000.00) - - (10,000.00) -
8/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 8/5/2024 - 10,000.00 - - 10,000.00 -
8/9/2024 Interflora Cash Flowers 78.00 A E PC IS-0345 8/9/2024 - 67.83 10.17 - 78.00 -
8/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 8/15/2024 - 69.57 10.43 - 80.00 -
8/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 8/15/2024 - 30.43 4.57 - 35.00 -
8/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 9/2/2024 - 2,000.00 300.00 - 2,300.00 -
8/15/2024 SA Airlines SA11988 Travel 2,520.00 A E B1 IS-0385 8/15/2024 - 2,191.30 328.70 - 2,520.00 -
8/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (90,000.00) E E B2 BS-0799 8/20/2024 - (90,000.00) - - (90,000.00) -
8/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 90,000.00 E E B1 BS-0799 8/20/2024 - 90,000.00 - - 90,000.00 -
8/21/2024 JSE Brokers Remittance Share investment 30,750.00 E E B1 BS-0400 8/21/2024 - 30,750.00 - - 30,750.00 -
8/24/2024 XY Traders Invoice11203 Commission 4,600.00 A E B1 IS-0320 9/24/2024 - 4,000.00 600.00 - 4,600.00 -
8/25/2024 Inland Revenue Return Sales Tax 36,421.95 E E B1 BS-1700 8/25/2024 - 36,421.95 - - 36,421.95 -
8/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 8/26/2024 - 45,000.00 - - 45,000.00 -
8/26/2024 HP Finance Debit Order Capital repayment 2,692.17 E E B1 BS-1805 8/26/2024 - 2,692.17 - - 2,692.17 -
8/26/2024 HP Finance Debit Order Interest paid 1,557.24 E E B1 IS-0600 8/26/2024 - 1,557.24 - - 1,557.24 -
8/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 8/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
8/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 8/26/2024 - 35,000.00 - - 35,000.00 -
8/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 9/6/2024 - 7,200.00 - - 7,200.00 -
8/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 9/6/2024 - 9,320.00 - - 9,320.00 -
8/27/2024 Waltons Invoice Stationery 234.00 A E B1 IS-0365 9/26/2024 - 203.48 30.52 - 234.00 -
8/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 78.00 E E B1 BS-0799 8/31/2024 - 78.00 - - 78.00 -
8/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (78.00) E E PC BS-0799 8/31/2024 - (78.00) - - (78.00) -
8/31/2024 Inland Revenue Return Provisional Tax 46,580.00 E E B1 IS-0700 8/31/2024 - 46,580.00 - - 46,580.00 -
8/31/2024 Google Card Online Marketing 11,400.00 E E B3 IS-0310 9/7/2024 - 11,400.00 - - 11,400.00 -
9/1/2024 IS Communications Invoice EXP28 Internet Service Provider 850.00 A E B1 IS-0375 10/1/2024 - 739.13 110.87 - 850.00 -
9/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 9/5/2024 - 320.00 48.00 - 368.00 -
9/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 9/5/2024 - (10,000.00) - - (10,000.00) -
9/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 9/5/2024 - 10,000.00 - - 10,000.00 -
9/13/2024 Training Inc Invoice Course 1,300.00 A E B1 IS-0380 10/13/2024 - 1,130.43 169.57 - 1,300.00 -
9/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 9/15/2024 - 69.57 10.43 - 80.00 -
9/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 9/15/2024 - 30.43 4.57 - 35.00 -
9/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 10/3/2024 - 2,000.00 300.00 - 2,300.00 -
9/18/2024 SA Airlines SA12146 Travel 5,620.00 A E B1 IS-0385 9/18/2024 - 4,886.96 733.04 - 5,620.00 -
9/18/2024 QA Attorneys Invoice Legal advice 6,500.00 A E B1 IS-0360 9/18/2024 - 5,652.17 847.83 - 6,500.00 -
9/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (50,000.00) E E B2 BS-0799 9/20/2024 - (50,000.00) - - (50,000.00) -
9/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 50,000.00 E E B1 BS-0799 9/20/2024 - 50,000.00 - - 50,000.00 -
9/21/2024 Interflora Cash Flowers 90.00 A E PC IS-0345 9/21/2024 - 78.26 11.74 - 90.00 -
9/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 9/26/2024 - 45,000.00 - - 45,000.00 -
9/26/2024 HP Finance Debit Order Capital repayment 2,714.60 E E B1 BS-1805 9/26/2024 - 2,714.60 - - 2,714.60 -
9/26/2024 HP Finance Debit Order Interest paid 1,534.81 E E B1 IS-0600 9/26/2024 - 1,534.81 - - 1,534.81 -
9/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 9/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
9/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 9/26/2024 - 35,000.00 - - 35,000.00 -
9/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 10/6/2024 - 7,200.00 - - 7,200.00 -
9/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 10/6/2024 - 9,320.00 - - 9,320.00 -
9/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E E B1 BS-0799 9/30/2024 - 100.00 - - 100.00 -
9/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (100.00) E E PC BS-0799 9/30/2024 - (100.00) - - (100.00) -
9/30/2024 Google Card Online Marketing 10,600.00 E E B3 IS-0310 10/7/2024 - 10,600.00 - - 10,600.00 -
10/1/2024 IS Communications Invoice EXP29 Internet Service Provider 850.00 A E B1 IS-0375 10/31/2024 - 739.13 110.87 - 850.00 -
10/4/2024 GF Supplies IN1185 Consumables 850.00 A E PC IS-0325 10/4/2024 - 739.13 110.87 - 850.00 -
10/4/2024 SA Airlines SA12741 Travel 4,410.00 A E B1 IS-0385 10/4/2024 - 3,834.78 575.22 - 4,410.00 -
10/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 10/5/2024 - 320.00 48.00 - 368.00 -
10/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (16,000.00) E E B3 BS-0799 10/5/2024 - (16,000.00) - - (16,000.00) -
10/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 16,000.00 E E B1 BS-0799 10/5/2024 - 16,000.00 - - 16,000.00 -
10/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 10/15/2024 - 69.57 10.43 - 80.00 -
10/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 10/15/2024 - 30.43 4.57 - 35.00 -
10/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 11/2/2024 - 2,000.00 300.00 - 2,300.00 -
10/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (70,000.00) E E B2 BS-0799 10/20/2024 - (70,000.00) - - (70,000.00) -
10/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 70,000.00 E E B1 BS-0799 10/20/2024 - 70,000.00 - - 70,000.00 -

Page 29 of 36
Example (Pty) Limited Balance Date
Expenses & Other Payments 2/28/2025 2/28/2025
© [Link] 2,085,377.36 61,039.00 2,038,411.97 46,965.39 - 2,085,377.36
Document Tax Inclusive Tax 1 Tax 2 Bank Account Payment Outstanding Exclusive Sales Tax 1 Sales Tax 2 Error
Date Supplier Reference Description Amount Code Code Code Number Date Balance Amount Amount Amount Inclusive Amount Code
10/22/2024 Waltons Invoice Stationery 289.00 A E B1 IS-0365 11/21/2024 - 251.30 37.70 - 289.00 -
10/25/2024 Inland Revenue Return Sales Tax 36,651.20 E E B1 BS-1700 10/25/2024 - 36,651.20 - - 36,651.20 -
10/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 10/26/2024 - 45,000.00 - - 45,000.00 -
10/26/2024 HP Finance Debit Order Capital repayment 2,737.22 E E B1 BS-1805 10/26/2024 - 2,737.22 - - 2,737.22 -
10/26/2024 HP Finance Debit Order Interest paid 1,512.19 E E B1 IS-0600 10/26/2024 - 1,512.19 - - 1,512.19 -
10/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 10/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
10/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 10/26/2024 - 35,000.00 - - 35,000.00 -
10/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 11/6/2024 - 7,200.00 - - 7,200.00 -
10/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 11/6/2024 - 9,320.00 - - 9,320.00 -
10/28/2024 Interflora Cash Flowers 218.00 A E PC IS-0345 10/28/2024 - 189.57 28.43 - 218.00 -
10/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 1,068.00 E E B1 BS-0799 10/31/2024 - 1,068.00 - - 1,068.00 -
10/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (1,068.00) E E PC BS-0799 10/31/2024 - (1,068.00) - - (1,068.00) -
10/31/2024 Google Card Online Marketing 10,350.00 E E B3 IS-0310 11/7/2024 - 10,350.00 - - 10,350.00 -
11/1/2024 IS Communications Invoice EXP30 Internet Service Provider 850.00 A E B1 IS-0375 12/1/2024 - 739.13 110.87 - 850.00 -
11/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 11/5/2024 - 320.00 48.00 - 368.00 -
11/5/2024 XY Traders Invoice 12987 Commission 4,427.50 A E B1 IS-0320 12/5/2024 - 3,850.00 577.50 - 4,427.50 -
11/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 11/5/2024 - (10,000.00) - - (10,000.00) -
11/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 11/5/2024 - 10,000.00 - - 10,000.00 -
11/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 11/15/2024 - 69.57 10.43 - 80.00 -
11/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 11/15/2024 - 30.43 4.57 - 35.00 -
11/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 12/3/2024 - 2,000.00 300.00 - 2,300.00 -
11/19/2024 Interflora Cash Flowers 102.00 A E PC IS-0345 11/19/2024 - 88.70 13.30 - 102.00 -
11/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (150,000.00) E E B2 BS-0799 11/20/2024 - (150,000.00) - - (150,000.00) -
11/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 150,000.00 E E B1 BS-0799 11/20/2024 - 150,000.00 - - 150,000.00 -
11/26/2024 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 11/26/2024 - 45,000.00 - - 45,000.00 -
11/26/2024 HP Finance Debit Order Capital repayment 2,760.03 E E B1 BS-1805 11/26/2024 - 2,760.03 - - 2,760.03 -
11/26/2024 HP Finance Debit Order Interest paid 1,489.38 E E B1 IS-0600 11/26/2024 - 1,489.38 - - 1,489.38 -
11/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 11/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
11/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 11/26/2024 - 35,000.00 - - 35,000.00 -
11/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 12/6/2024 - 7,200.00 - - 7,200.00 -
11/26/2024 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 12/6/2024 - 9,320.00 - - 9,320.00 -
11/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 102.00 E E B1 BS-0799 11/30/2024 - 102.00 - - 102.00 -
11/30/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (102.00) E E PC BS-0799 11/30/2024 - (102.00) - - (102.00) -
11/30/2024 Google Card Online Marketing 10,240.00 E E B3 IS-0310 12/7/2024 - 10,240.00 - - 10,240.00 -
12/1/2024 IS Communications Invoice EXP31 Internet Service Provider 850.00 A E B1 IS-0375 12/31/2024 - 739.13 110.87 - 850.00 -
12/5/2024 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 12/5/2024 - 320.00 48.00 - 368.00 -
12/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 12/5/2024 - (10,000.00) - - (10,000.00) -
12/5/2024 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 12/5/2024 - 10,000.00 - - 10,000.00 -
12/6/2024 Interflora Cash Flowers 96.00 A E PC IS-0345 12/6/2024 - 83.48 12.52 - 96.00 -
12/15/2024 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 12/15/2024 - 69.57 10.43 - 80.00 -
12/15/2024 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 12/15/2024 - 30.43 4.57 - 35.00 -
12/15/2024 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 1/2/2025 - 2,000.00 300.00 - 2,300.00 -
12/17/2024 Newscorp M00353051 Subscriptions 120.00 A E B1 IS-0355 1/16/2025 - 104.35 15.65 - 120.00 -
12/17/2024 Waltons Invoice Stationery 310.00 A E B1 IS-0365 1/16/2025 - 269.57 40.43 - 310.00 -
12/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer (90,000.00) E E B2 BS-0799 12/20/2024 - (90,000.00) - - (90,000.00) -
12/20/2024 Example (Pty) Ltd Transfer Inter Account Transfer 90,000.00 E E B1 BS-0799 12/20/2024 - 90,000.00 - - 90,000.00 -
12/22/2024 GF Supplies IN1192 Consumables 648.00 A E PC IS-0325 12/22/2024 - 563.48 84.52 - 648.00 -
12/25/2024 Inland Revenue Return Sales Tax 40,976.74 E E B1 BS-1700 12/25/2024 - 40,976.74 - - 40,976.74 -
12/26/2024 Example (Pty) Ltd Payroll Salaries 75,000.00 E E B2 IS-0410 12/26/2024 - 75,000.00 - - 75,000.00 -
12/26/2024 HP Finance Debit Order Capital repayment 2,783.03 E E B1 BS-1805 12/26/2024 - 2,783.03 - - 2,783.03 -
12/26/2024 HP Finance Debit Order Interest paid 1,466.38 E E B1 IS-0600 12/26/2024 - 1,466.38 - - 1,466.38 -
12/26/2024 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 12/26/2024 - 12,000.00 1,800.00 - 13,800.00 -
12/26/2024 Example (Pty) Ltd Payroll Net Pay - Staff 70,000.00 E E B2 IS-0405 12/26/2024 - 70,000.00 - - 70,000.00 -
12/26/2024 Example (Pty) Ltd Payroll Deductions - Staff 14,400.00 E E B2 IS-0405 1/6/2025 - 14,400.00 - - 14,400.00 -
12/26/2024 Example (Pty) Ltd Payroll Deductions - Management 13,200.00 E E B2 IS-0410 1/6/2025 - 13,200.00 - - 13,200.00 -
12/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 744.00 E E B1 BS-0799 12/31/2024 - 744.00 - - 744.00 -
12/31/2024 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (744.00) E E PC BS-0799 12/31/2024 - (744.00) - - (744.00) -
12/31/2024 Google Card Online Marketing 10,580.00 E E B3 IS-0310 1/7/2025 - 10,580.00 - - 10,580.00 -
1/1/2025 IS Communications Invoice EXP32 Internet Service Provider 850.00 A E B1 IS-0375 1/31/2025 - 739.13 110.87 - 850.00 -

Page 30 of 36
Example (Pty) Limited Balance Date
Expenses & Other Payments 2/28/2025 2/28/2025
© [Link] 2,085,377.36 61,039.00 2,038,411.97 46,965.39 - 2,085,377.36
Document Tax Inclusive Tax 1 Tax 2 Bank Account Payment Outstanding Exclusive Sales Tax 1 Sales Tax 2 Error
Date Supplier Reference Description Amount Code Code Code Number Date Balance Amount Amount Amount Inclusive Amount Code
1/5/2025 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 1/5/2025 - 320.00 48.00 - 368.00 -
1/5/2025 Example (Pty) Ltd Transfer Inter Account Transfer (10,000.00) E E B3 BS-0799 1/5/2025 - (10,000.00) - - (10,000.00) -
1/5/2025 Example (Pty) Ltd Transfer Inter Account Transfer 10,000.00 E E B1 BS-0799 1/5/2025 - 10,000.00 - - 10,000.00 -
1/15/2025 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 1/15/2025 - 69.57 10.43 - 80.00 -
1/15/2025 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 1/15/2025 - 30.43 4.57 - 35.00 -
1/15/2025 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 2/2/2025 - 2,000.00 300.00 - 2,300.00 -
1/16/2025 Interflora Cash Flowers 105.00 A E PC IS-0345 1/16/2025 - 91.30 13.70 - 105.00 -
1/20/2025 Example (Pty) Ltd Transfer Inter Account Transfer (50,000.00) E E B2 BS-0799 1/20/2025 - (50,000.00) - - (50,000.00) -
1/20/2025 Example (Pty) Ltd Transfer Inter Account Transfer 50,000.00 E E B1 BS-0799 1/20/2025 - 50,000.00 - - 50,000.00 -
1/26/2025 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 1/26/2025 - 45,000.00 - - 45,000.00 -
1/26/2025 HP Finance Debit Order Capital repayment 3,451.91 E E B1 BS-1805 1/26/2025 - 3,451.91 - - 3,451.91 -
1/26/2025 HP Finance Debit Order Interest paid 1,859.85 E E B1 IS-0600 1/26/2025 - 1,859.85 - - 1,859.85 -
1/26/2025 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 1/26/2025 - 12,000.00 1,800.00 - 13,800.00 -
1/26/2025 Training Inc Invoice Training 2,100.00 A E B1 IS-0380 1/31/2025 - 1,826.09 273.91 - 2,100.00 -
1/26/2025 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 1/26/2025 - 35,000.00 - - 35,000.00 -
1/26/2025 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 2/6/2025 - 7,200.00 - - 7,200.00 -
1/26/2025 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 2/6/2025 - 9,320.00 - - 9,320.00 -
1/31/2025 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 100.00 E E B1 BS-0799 1/31/2025 - 100.00 - - 100.00 -
1/31/2025 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (100.00) E E PC BS-0799 1/31/2025 - (100.00) - - (100.00) -
1/31/2025 Google Card Online Marketing 11,203.00 E E B3 IS-0310 2/7/2025 - 11,203.00 - - 11,203.00 -
2/1/2025 IS Communications Invoice EXP33 Internet Service Provider 850.00 A E B1 IS-0375 850.00 739.13 110.87 - 850.00 -
2/5/2025 EAG Brokers Debit Order Insurance 368.00 A E B1 IS-0340 2/5/2025 - 320.00 48.00 - 368.00 -
2/5/2025 Example (Pty) Ltd Transfer Inter Account Transfer (15,000.00) E E B3 BS-0799 2/5/2025 - (15,000.00) - - (15,000.00) -
2/5/2025 Example (Pty) Ltd Transfer Inter Account Transfer 15,000.00 E E B1 BS-0799 2/5/2025 - 15,000.00 - - 15,000.00 -
2/11/2025 Waltons Invoice Stationery 289.00 A E B1 IS-0365 289.00 251.30 37.70 - 289.00 -
2/15/2025 Capital Bank Bank Statement Service Fees 80.00 A E B1 IS-0315 2/15/2025 - 69.57 10.43 - 80.00 -
2/15/2025 Capital Bank Bank Statement Service Fees 35.00 A E B2 IS-0315 2/15/2025 - 30.43 4.57 - 35.00 -
2/15/2025 IAS Accountants Invoice Monthly Accounting 2,300.00 A E B1 IS-0305 2,300.00 2,000.00 300.00 - 2,300.00 -
2/20/2025 Example (Pty) Ltd Transfer Inter Account Transfer (80,000.00) E E B2 BS-0799 2/20/2025 - (80,000.00) - - (80,000.00) -
2/20/2025 Example (Pty) Ltd Transfer Inter Account Transfer 80,000.00 E E B1 BS-0799 2/20/2025 - 80,000.00 - - 80,000.00 -
2/25/2025 Inland Revenue Return Sales Tax 31,218.52 E E B1 BS-1700 2/25/2025 - 31,218.52 - - 31,218.52 -
2/25/2025 Interflora Cash Flowers 75.00 A E PC IS-0345 2/25/2025 - 65.22 9.78 - 75.00 -
2/26/2025 DF Equipment Invoice Office equipment 11,730.00 A E B1 BS-0020 11,730.00 10,200.00 1,530.00 - 11,730.00 -
2/26/2025 Example (Pty) Ltd Payroll Salaries 45,000.00 E E B2 IS-0410 2/26/2025 - 45,000.00 - - 45,000.00 -
2/26/2025 HP Finance Debit Order Capital repayment 3,480.68 E E B1 BS-1805 2/26/2025 - 3,480.68 - - 3,480.68 -
2/26/2025 HP Finance Debit Order Interest paid 1,831.09 E E B1 IS-0600 2/26/2025 - 1,831.09 - - 1,831.09 -
2/26/2025 PR Properties Debit Order Rent 13,800.00 A E B1 IS-0350 2/26/2025 - 12,000.00 1,800.00 - 13,800.00 -
2/26/2025 Example (Pty) Ltd Payroll Net Pay - Staff 35,000.00 E E B2 IS-0405 2/26/2025 - 35,000.00 - - 35,000.00 -
2/26/2025 Example (Pty) Ltd Payroll Deductions - Staff 7,200.00 E E B2 IS-0405 7,200.00 7,200.00 - - 7,200.00 -
2/26/2025 Example (Pty) Ltd Payroll Deductions - Management 9,320.00 E E B2 IS-0410 9,320.00 9,320.00 - - 9,320.00 -
2/28/2025 XY Traders Invoice 14278 Commission 17,250.00 A E B1 IS-0320 17,250.00 15,000.00 2,250.00 - 17,250.00 -
2/28/2025 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement 75.00 E E B1 BS-0799 2/28/2025 - 75.00 - - 75.00 -
2/28/2025 Example (Pty) Ltd Bank Statement Petty Cash Reimbursement (75.00) E E PC BS-0799 2/28/2025 - (75.00) - - (75.00) -
2/28/2025 Inland Revenue Return Provisional Tax 24,185.00 E E B1 IS-0700 2/28/2025 - 24,185.00 - - 24,185.00 -
2/28/2025 None Journal Depreciation 18,232.00 E E JC IS-0505 2/28/2025 - 18,232.00 - - 18,232.00 -
2/28/2025 None Journal Depreciation 12,190.00 E E JC IS-0505 2/28/2025 - 12,190.00 - - 12,190.00 -
2/28/2025 None Journal Depreciation (18,232.00) E E JC BS-0115 2/28/2025 - (18,232.00) - - (18,232.00) -
2/28/2025 None Journal Depreciation (12,190.00) E E JC BS-0120 2/28/2025 - (12,190.00) - - (12,190.00) -
2/28/2025 None Journal Amortization 14,720.00 E E JC IS-0510 2/28/2025 - 14,720.00 - - 14,720.00 -
2/28/2025 None Journal Amortization (14,720.00) E E JC BS-0315 2/28/2025 - (14,720.00) - - (14,720.00) -
2/28/2025 None Journal Dividend Declared 50,000.00 E E JC IS-1000 2/28/2025 - 50,000.00 - - 50,000.00 -
2/28/2025 None Journal Dividend Declared (50,000.00) E E JC BS-1405 2/28/2025 - (50,000.00) - - (50,000.00) -
2/28/2025 Google Card Online Marketing 12,100.00 E E B3 IS-0310 12,100.00 12,100.00 - - 12,100.00 -

Page 31 of 36
Example (Pty) Limited
Income Statement 3/1/2023
© [Link] 2/29/2024
Description Mar-2024 Apr-2024 May-2024 Jun-2024 Jul-2024 Aug-2024 Sep-2024 Oct-2024 Nov-2024 Dec-2024 Jan-2025 Feb-2025 Total 2025 Total 2024
Software Sales 121,591.39 136,970.00 183,080.00 146,540.00 133,200.00 127,970.00 161,200.00 176,530.00 131,320.00 113,045.00 136,690.00 152,100.00 1,720,236.39 -
Advertising Income 12,500.00 10,300.00 15,200.00 9,500.00 22,300.00 21,400.00 15,100.00 18,400.00 22,150.00 10,320.00 15,400.00 24,350.00 196,920.00 -
Commission Received 1,486.96 1,200.00 1,400.00 1,600.00 2,100.00 1,900.00 1,800.00 2,200.00 2,400.00 1,540.00 2,000.00 2,700.00 22,326.96 -
Total Turnover 135,578.35 148,470.00 199,680.00 157,640.00 157,600.00 151,270.00 178,100.00 197,130.00 155,870.00 124,905.00 154,090.00 179,150.00 1,939,483.35 -
Other Income 150.01 120.65 160.23 170.21 165.23 166.24 164.21 165.89 167.25 166.45 166.23 167.25 1,929.85 -
Operating Expenses
Accounting Fees 1,982.61 2,000.00 2,000.00
On this sheet: 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 23,982.61 -
Advertising & Marketing This10,000.00
monthly income statement 11,020.00
24,800.00 is automatically compiled based
10,500.00 on the
10,850.00 11,400.00 10,600.00 10,350.00 10,240.00 10,580.00 11,203.00 12,100.00 143,643.00 -
Bank Charges transactions
79.30 entered100.00
on the Income 100.00
and Expenses sheets.
100.00 No user100.00
input is 100.00 100.00 100.00 100.00 100.00 100.00 100.00 1,179.30 -
Commission required on- this sheet. -The monthly reporting periods
5,000.00 - are determined
- 4,000.00 - - 3,850.00 - - 15,000.00 27,850.00 -
Computer Expenses based on -the reporting year specified on
2,173.91 - the Setup sheet
- and includes- 12 - - 739.13 - 563.48 - - 3,476.52 -
Consumables & Cleaning monthly periods.
- Additional
- accounts can- be added and - the key 2,500.00
in column - - - - - - - 2,500.00 -
Entertainment A determines
- whether individual
- account- balances or account
- group totals
- - - - - - - - - -
Insurance are displayed.
317.22 320.00 320.00 320.00 320.00 320.00 320.00 320.00 320.00 320.00 320.00 320.00 3,837.22 -
Office Expenses 78.26 75.65 56.52 95.65 25.22 67.83 78.26 189.57 88.70 83.48 91.30 65.22 995.65 -
Office Rent 11,895.65 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 143,895.65 -
Postage 415.65 - - - - - - - - 104.35 - - 520.00 -
Professional & Legal Fees - - - - - - 5,652.17 - - - - - 5,652.17 -
Stationery - - 853.91 - 661.74 203.48 - 251.30 - 269.57 - 251.30 2,491.30 -
Subscriptions & Memberships - - - - 5,200.00 - - - - - - - 5,200.00 -
Telephone & Internet 730.43 739.13 739.13 739.13 739.13 739.13 739.13 739.13 739.13 739.13 739.13 739.13 8,860.87 -
Training - - 1,086.96 - - - 1,130.43 - - - 1,826.09 - 4,043.48 -
Travelling & Accommodation 104.35 - 860.87 1,826.09 - 2,191.30 4,886.96 3,834.78 - - - - 13,704.35 -
Utilities - - - - - - - - - - - - - -
Total Operating Expenses 25,603.48 42,208.70 34,037.39 27,580.87 34,396.09 33,021.74 37,506.96 30,523.91 29,337.83 26,760.00 28,279.52 42,575.65 391,832.13 -
Staff Costs
Salaries & Wages - Staff 42,200.00 42,200.00 42,200.00 42,200.00 42,200.00 42,200.00 42,200.00 42,200.00 42,200.00 84,400.00 42,200.00 42,200.00 548,600.00 -
Salaries & Wages - Management 54,320.00 54,320.00 54,320.00 54,320.00 54,320.00 54,320.00 54,320.00 54,320.00 54,320.00 88,200.00 54,320.00 54,320.00 685,720.00 -
Total Staff Costs 96,520.00 96,520.00 96,520.00 96,520.00 96,520.00 96,520.00 96,520.00 96,520.00 96,520.00 172,600.00 96,520.00 96,520.00 1,234,320.00 -
Other Expenses - - - - - - - - - - - - - -
Depreciation & Amortization
Depreciation - - - - - - - - - - - 30,422.00 30,422.00 -
Amortization - - - - - - - - - - - 14,720.00 14,720.00 -
Total Depreciation & Amortization - - - - - - - - - - - 45,142.00 45,142.00 -
Profit / (Loss) before Interest & Tax 13,604.88 9,861.95 69,282.84 33,709.34 26,849.14 21,894.50 44,237.25 70,251.98 30,179.42 (74,288.55) 29,456.71 (4,920.40) 270,119.07 -
Interest Paid 1,666.67 1,645.14 1,623.44 1,601.56 1,579.49 1,557.24 1,534.81 1,512.19 1,489.38 1,466.38 1,859.85 1,831.09 19,367.24 -
Profit / (Loss) before tax 11,938.21 8,216.81 67,659.40 32,107.78 25,269.65 20,337.26 42,702.44 68,739.79 28,690.04 (75,754.93) 27,596.86 (6,751.49) 250,751.83 -
Taxation Paid - - - - - 46,580.00 - - - - - 24,185.00 70,765.00 -
Profit / (Loss) for the year 11,938.21 8,216.81 67,659.40 32,107.78 25,269.65 (26,242.74) 42,702.44 68,739.79 28,690.04 (75,754.93) 27,596.86 (30,936.49) 179,986.83 -
Dividends Paid - - - - - - - - - - - 50,000.00 50,000.00 -
Retained earnings for the year 11,938.21 8,216.81 67,659.40 32,107.78 25,269.65 (26,242.74) 42,702.44 68,739.79 28,690.04 (75,754.93) 27,596.86 (80,936.49) 129,986.83 -

Page 32 of 36
Example (Pty) Limited
Cash Flow Statement
© [Link]
Description Mar-2024 Apr-2024 May-2024 Jun-2024 Jul-2024 Aug-2024 Sep-2024 Oct-2024 Nov-2024 Dec-2024 Jan-2025 Feb-2025 Total 2025
Cash flows from operating activities
Profit / (Loss) for the year 11,938.21 8,216.81 67,659.40 32,107.78 25,269.65 (26,242.74) 42,702.44 68,739.79 28,690.04 (75,754.93) 27,596.86 (30,936.49) 179,986.83
Interest Paid 1,666.67 1,645.14 1,623.44 1,601.56 1,579.49 1,557.24 1,534.81 1,512.19 1,489.38 1,466.38 1,859.85 1,831.09 19,367.24
Taxation Paid - - - - - 46,580.00 - - - - - 24,185.00 70,765.00
On this sheet:
Adjustment for non-cash expenses:
This monthly cash flow statement is automatically
Depreciation - - - - - - - - - - - 30,422.00 30,422.00
compiled based on the automated income statement
Amortization - - - - - - - - - - - 14,720.00 14,720.00
and balance sheet balances. No user input is required
Reserves - - - - - - - - - - - - -
on this sheet.
Changes in operating assets & liabilities
Trade Debtors (4,022.10) (17,417.40) 49,023.50 (59,229.00) 138,241.00 (128,785.50) 23,285.50 (17,445.00) (82,768.00) 34,803.00 53,380.00 64,250.00 53,316.00
Loans & Advances 12,000.00 - - - - - - - - - - - 12,000.00
Other Debtors - 15,000.00 - - - - - - - - - - 15,000.00
Cash On Hand - - - - - - - - - - - - -
Trade Creditors (15,875.00) 17,959.50 (10,665.50) (6,402.00) 9,116.00 (4,232.00) (3,484.00) (2,111.00) 4,878.50 6,572.50 (10,887.00) 31,016.00 15,886.00
Sales Tax 14,189.23 (18,632.53) 24,219.39 (20,357.22) 16,763.09 (20,184.71) 20,413.96 (12,867.79) 17,193.33 (28,172.74) 18,414.52 (14,099.87) (3,121.35)
Accruals - - - - - - - - - - - - -
Other Provisions - - - - - - - - - - - - -
Cash generated from operations 19,897.01 6,771.52 131,860.23 (52,278.88) 190,969.23 (131,307.71) 84,452.71 37,828.19 (30,516.75) (61,085.79) 90,364.23 121,387.73 408,341.72
Interest Paid (1,666.67) (1,645.14) (1,623.44) (1,601.56) (1,579.49) (1,557.24) (1,534.81) (1,512.19) (1,489.38) (1,466.38) (1,859.85) (1,831.09) (19,367.24)
Taxation Paid - - - - - (46,580.00) - - - - - (24,185.00) (70,765.00)
Net cash from operating activities 18,230.34 5,126.38 130,236.79 (53,880.44) 189,389.74 (179,444.95) 82,917.90 36,316.00 (32,006.13) (62,552.17) 88,504.38 95,371.64 318,209.48
Cash flows from investing activities
Property, Plant & Equipment - Cost - (15,450.00) - - - - - - - - - (10,200.00) (25,650.00)
Intangible Assets - Cost - - - - - - - - - - - - -
Investments - - - - - (30,750.00) - - - - - - (30,750.00)
Net cash used in investing activities - (15,450.00) - - - (30,750.00) - - - - - (10,200.00) (56,400.00)
Cash flows from financing activities
Shareholders' Contributions - - - - - - - - - - - - -
Dividends Paid - - - - - - - - - - - - -
Long Term Liabilities - Proceeds - - - - - - - - - - 50,000.00 - 50,000.00
Long Term Liabilities - Repayments (2,582.74) (2,604.27) (2,625.97) (2,647.85) (2,669.92) (2,692.17) (2,714.60) (2,737.22) (2,760.03) (2,783.03) (3,451.91) (3,480.68) (33,750.39)
Net cash from financing activities (2,582.74) (2,604.27) (2,625.97) (2,647.85) (2,669.92) (2,692.17) (2,714.60) (2,737.22) (2,760.03) (2,783.03) 46,548.09 (3,480.68) 16,249.61
Increase / (Decrease) in cash equivalents 15,647.60 (12,927.89) 127,610.82 (56,528.29) 186,719.82 (212,887.12) 80,203.30 33,578.78 (34,766.16) (65,335.20) 135,052.47 81,690.96 278,059.09
Cash & cash equivalents at beginning of year 107,750.50 123,398.10 110,470.21 238,081.03 181,552.74 368,272.56 155,385.44 235,588.74 269,167.52 234,401.36 169,066.16 304,118.63 107,750.50
Cash & cash equivalents at end of year 123,398.10 110,470.21 238,081.03 181,552.74 368,272.56 155,385.44 235,588.74 269,167.52 234,401.36 169,066.16 304,118.63 385,809.59 385,809.59

Page 33 of 36
Example (Pty) Limited
Balance Sheet
© [Link]
Description Feb-2024 Mar-2024 Apr-2024 May-2024 Jun-2024 Jul-2024 Aug-2024 Sep-2024 Oct-2024 Nov-2024 Dec-2024 Jan-2025 Feb-2025 Total 2025
ASSETS
Non-Current Assets
Property, Plant & Equipment - Cost 183,750.00 183,750.00 199,200.00 199,200.00 199,200.00 199,200.00 199,200.00 199,200.00 199,200.00 199,200.00 199,200.00 199,200.00 209,400.00 209,400.00
Property, Plant & Equipment - Accum Dep (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (34,500.00) (64,922.00) (64,922.00)
Intangible Assets - Cost 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00 147,200.00
Intangible Assets - Amortization (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (29,440.00) (44,160.00) (44,160.00)
Investments 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 180,750.00 180,750.00 180,750.00 180,750.00 180,750.00 180,750.00 180,750.00 180,750.00
417,010.00 417,010.00 432,460.00 432,460.00 432,460.00 432,460.00 463,210.00 463,210.00 463,210.00 463,210.00 463,210.00 463,210.00 428,268.00 428,268.00
Current Assets
Trade Debtors 146,376.00 150,398.10 167,815.50
On this sheet: 118,792.00 178,021.00 39,780.00 168,565.50 145,280.00 162,725.00 245,493.00 210,690.00 157,310.00 93,060.00 93,060.00
Loans & Advances This monthly balance sheet
12,000.00 - is automatically
- calculated- based - - - - - - - - - -
Other Debtors on 15,000.00
the transactions entered on the Income
15,000.00 - and Expenses
- - - - - - - - - - -
B1 Bank Account sheets. No user input
45,250.50 is required
113,782.29 on this sheet.213,294.34
104,788.75 Balance sheet158,980.84 333,090.43 105,142.07 211,726.16 251,194.05 144,765.64 128,908.99 261,695.23 340,576.94 340,576.94
B2 Bank Account balances are calculated
61,500.00 8,615.81based on4,681.46
account groups by default 17,401.90
18,586.69 30,512.13 46,423.37 21,432.58 10,143.47 82,155.72 32,917.17 35,768.40 34,780.65 34,780.65
B3 Bank Account but can also
- be included- individually by- changing the key in 4,180.00
5,200.00 3,680.00 2,830.00 1,430.00 6,830.00 6,480.00 6,240.00 5,660.00 9,457.00 9,457.00
PC Petty Cash
column A.
1,000.00 1,000.00 1,000.00 1,000.00 990.00 990.00 990.00 1,000.00 1,000.00 1,000.00 1,000.00 995.00 995.00 995.00
GL Journal Control - - - - - - - - - - - - - -
Cash On Hand - - - - - - - - - - - - - -
281,126.50 288,796.20 278,285.71 356,873.03 359,573.74 408,052.56 323,950.94 380,868.74 431,892.52 479,894.36 379,756.16 461,428.63 478,869.59 478,869.59
Total Assets 698,136.50 705,806.20 710,745.71 789,333.03 792,033.74 840,512.56 787,160.94 844,078.74 895,102.52 943,104.36 842,966.16 924,638.63 907,137.59 907,137.59
EQUITY & LIABILITIES
Equity
Shareholders' Contributions 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Reserves - - - - - - - - - - - - - -
Retained Earnings - Opening 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50 432,643.50
Retained Earnings - Current - 11,938.21 20,155.02 87,814.42 119,922.20 145,191.86 118,949.12 161,651.56 230,391.35 259,081.39 183,326.46 210,923.32 129,986.83 129,986.83
432,743.50 444,681.71 452,898.52 520,557.92 552,665.70 577,935.36 551,692.62 594,395.06 663,134.85 691,824.89 616,069.96 643,666.82 562,730.33 562,730.33
Non-Current Liabilities
Long Term Liabilities 200,000.00 197,417.26 194,812.99 192,187.02 189,539.17 186,869.25 184,177.08 181,462.48 178,725.26 175,965.23 173,182.20 219,730.29 216,249.61 216,249.61
200,000.00 197,417.26 194,812.99 192,187.02 189,539.17 186,869.25 184,177.08 181,462.48 178,725.26 175,965.23 173,182.20 219,730.29 216,249.61 216,249.61
Current Liabilities
Trade Creditors 45,153.00 29,278.00 47,237.50 36,572.00 30,170.00 39,286.00 35,054.00 31,570.00 29,459.00 34,337.50 40,910.00 30,023.00 61,039.00 61,039.00
Accruals - - - - - - - - - - - - - -
Sales Tax 1 - National / Federal 20,240.00 34,429.23 15,796.70 40,016.09 19,658.87 36,421.95 16,237.24 36,651.20 23,783.41 40,976.74 12,804.00 31,218.52 17,118.65 17,118.65
Sales Tax 2 - State - - - - - - - - - - - - - -
Provision for Taxation - - - - - - - - - - - - - -
Dividends Payable - - - - - - - - - - - - 50,000.00 50,000.00
Other Provisions - - - - - - - - - - - - - -
65,393.00 63,707.23 63,034.20 76,588.09 49,828.87 75,707.95 51,291.24 68,221.20 53,242.41 75,314.24 53,714.00 61,241.52 128,157.65 128,157.65
Total Equity & Liabilities 698,136.50 705,806.20 710,745.71 789,333.03 792,033.74 840,512.56 787,160.94 844,078.74 895,102.52 943,104.36 842,966.16 924,638.63 907,137.59 907,137.59

Page 34 of 36
Example (Pty) Limited
Bank Accounts
© [Link]
Bank Code B1 B1
Month Feb/2025 2/28/2025

Daily For Selected Month Monthly For Financial Year

Day Opening Income Expenses Closing Month Opening Income Expenses Closing
2/1/2025 261,695.23 - - 261,695.23 Mar/2024 45,250.50 148,086.00 (79,554.21) 113,782.29
2/2/2025 261,695.23 - (2,300.00) 259,395.23 Apr/2024 113,782.29 139,278.10 (148,271.64) 104,788.75
2/3/2025 259,395.23 - - 259,395.23 May/2024 104,788.75 266,075.50 (157,569.91) 213,294.34
2/4/2025 259,395.23 - - 259,395.23 Jun/2024 213,294.34 105,432.00 (159,745.50) 158,980.84
2/5/2025 259,395.23 - (15,368.00) 244,027.23
On this sheet: Jul/2024 158,980.84 306,636.00 (132,526.41) 333,090.43
2/6/2025 244,027.23 This sheet- contains an - 244,027.23
analysis of bank Aug/2024
account 333,090.43 19,665.00 (247,613.36) 105,142.07
2/7/2025 244,027.23 movements
3,105.00 on a daily &- monthly basis. The appropriate
247,132.23 Sep/2024 105,142.07 204,435.50 (97,851.41) 211,726.16
2/8/2025 247,132.23 bank account
- and month - can be selected at the
247,132.23 top of
Oct/2024 211,726.16 191,394.50 (151,926.61) 251,194.05
2/9/2025 247,132.23 the sheet- and all other calculations
- are automated.
247,132.23 Nov/2024 251,194.05 74,760.00 (181,188.41) 144,765.64
2/10/2025 247,132.23 - - 247,132.23 Dec/2024 144,765.64 152,789.00 (168,645.65) 128,908.99
2/11/2025 247,132.23 - - 247,132.23 Jan/2025 128,908.99 218,126.00 (85,339.76) 261,695.23
2/12/2025 247,132.23 - - 247,132.23 Feb/2025 261,695.23 251,220.00 (172,338.29) 340,576.94
2/13/2025 247,132.23 - - 247,132.23
2/14/2025 247,132.23 - - 247,132.23
2/15/2025 247,132.23 - (80.00) 247,052.23
2/16/2025 247,052.23 - - 247,052.23
2/17/2025 247,052.23 - - 247,052.23
2/18/2025 247,052.23 - - 247,052.23
2/19/2025 247,052.23 - - 247,052.23
2/20/2025 247,052.23 - (80,000.00) 167,052.23
2/21/2025 167,052.23 - - 167,052.23
2/22/2025 167,052.23 - - 167,052.23
2/23/2025 167,052.23 - - 167,052.23
2/24/2025 167,052.23 - - 167,052.23
2/25/2025 167,052.23 - (31,218.52) 135,833.71
2/26/2025 135,833.71 110,000.00 (19,111.77) 226,721.94
2/27/2025 226,721.94 - - 226,721.94
2/28/2025 226,721.94 138,115.00 (24,260.00) 340,576.94

Page 35 of 36
Example (Pty) Limited Tax Type Tax Code 1 Tax Code 2
Sales Tax 0 * *
© [Link]
Sales Tax Inclusive Monthly Effective %
Month Opening Output Input Payment Closing Output Input Net Output Input
3/31/2024 20,240.00 16,529.75 (2,340.52) - 34,429.23 152,258.11 (116,713.41) 14,189.23 12.2% 2.0%
4/30/2024 34,429.23 20,725.50 (4,928.80) (34,429.23) 15,796.70 169,316.15 (182,786.14) 15,796.70 13.9% 2.8%
5/31/2024 15,796.70 27,672.00 (3,452.61) - 40,016.09 227,512.23 (138,259.41) 24,219.39 13.8% 2.6%
6/30/2024 40,016.09 22,221.00 (2,562.13) (40,016.09) 19,658.87 180,031.21 (170,928.50) 19,658.87 14.1% 1.5%
7/31/2024 19,658.87 20,295.00 (3,531.91) - 36,421.95 178,060.23 (138,697.41) 16,763.09 12.9% 2.6%
8/31/2024 36,421.95 19,480.50 (3,243.26) (36,421.95) 16,237.24 170,916.74 (250,786.36) 16,237.24 12.9% 1.3%
9/30/2024 16,237.24 24,450.00 (4,036.04) - 36,651.20 202,714.21 (142,312.41) 20,413.96 13.7% 2.9%
10/31/2024 36,651.20 26,809.50 (3,026.09) (36,651.20) 23,783.41 224,105.39 (170,970.61) 23,783.41 13.6% 1.8%
11/30/2024 23,783.41 20,058.00 (2,864.67) - 40,976.74 176,095.25 (132,971.91) 17,193.33 12.9% 2.2%
12/31/2024 40,976.74 15,231.00 (2,427.00) (40,976.74) 12,804.00 140,302.45 (247,013.15) 12,804.00 12.2% 1.0%
1/31/2025 12,804.00 20,976.00 (2,561.48) - 31,218.52 225,232.23 (132,672.76) 18,414.52 10.3% 2.0%
2/28/2025 31,218.52 23,220.00 (6,101.35) (31,218.52) 17,118.65 202,537.25 (216,112.29) 17,118.65 12.9% 2.9%

On this sheet:
This sheet contains a monthly sales tax analysis. All the
calculations are automated. You can select the tax type and any
of the individual sales tax codes at the top of the sheet to view
the output and input values for any tax type or tax code. The
template provides for two default tax types for national or
federal sales tax and state sales tax.

Page 36 of 36