100% Unique Excel Templates!
  • Accounting in Excel
  • Financial Statements
  • Cash Flow Forecasts
  • Payroll & Leave
  • Management Accounts
  • Fixed Assets Registers
  • Business Valuations
  • Product Costings
And A Lot More!
  • Try Before You Buy!
  • Click the Trial buttons and enable our 100% safe trial version macros to try out the templates...
  • No Macros? View Our Samples!
  • Click the Sample buttons to view the layout of the templates in a file format that cannot be edited...
  • Ready To Buy?
  • Simply click the Buy Now buttons to add the appropriate template to your shopping cart...
  • Download all our unique templates!
  • Register for a full membership in order to download ALL 40+ of our unique templates!
  • Special Offer
  • Click to select & buy any 3 of our unique templates for only ZAR800!
  • Register
  • Click to register & buy ALL 40+ of our templates for only ZAR3,000!
01 Financial Statements Template
Compile comprehensive financial statements based on International Financial Reporting Standards for small & medium enterprises (IFRS for SME's) from any trial balance regardless of the structure of the accounts that are included in the trial balance. The financial statements are automatically populated based on a pre-defined reporting class code which is linked to each trial balance account.
  • Comprehensive financial statements based on IFRS for SME's
  • Accommodates any account structure and trial balance
  • Link account codes to pre-defined financial statement reporting classes
  • Incorporates non-trial balance financial data
  • Roll financial statements forward or back by changing a single input cell
  • Automatically compiles most of the financial statements
  • Includes trial balance checking and import feature
  • Customizable for any type of business
02 Management Accounts Template
Compile comprehensive monthly management accounts from any trial balance regardless of the accounts structure. Each account in the trial balance needs to be linked to a pre-defined reporting class code and the template produces an automated income statement, cash flow statement and balance sheet which includes actual & prior year results and a forecast.
  • Comprehensive automated management accounts
  • Includes income statement, cash flow statement and balance sheet
  • Compares actual results with forecast or budget and prior year results
  • Includes monthly & year-to-date analysis
  • Includes monthly income statement for analysis of income & expenses
  • Accommodates any account structure and trial balance format
  • Link account codes to pre-defined financial statement reporting classes
  • Easy to roll forward for subsequent years and to update on monthly basis
  • Includes trial balance checking and import feature
  • Customizable for any type of business
03 Basic Accounting Template
Record income & expenses and automatically produce a trial balance, monthly & annual income statement and a monthly balance sheet. The template can be customized by editing the default expense accounts and adding an unlimited number of additional accounts. Roll the template forward for future financial periods by simply changing a date in a single input cell.
  • Suitable for any business
  • Record income & expenses
  • Customize list of accounts and create additional expense accounts
  • Sales tax calculation & reporting
  • Accommodates multiple bank accounts and petty cash transactions
  • 12 Month reporting period based on a user defined start date
  • Accommodates any year end period
  • Automated monthly & annual income statement & balance sheet
04 Excel Accounting Template - Service Based
Record income, generate tax invoices, record expenses, calculate sales tax, account for non-cash entries and automatically produce a detailed trial balance, bank reconciliation, monthly & annual income statement & cash flow report and a monthly balance sheet. This template is a complete Excel based accounting solution for service based businesses.
  • Suitable for any service based business
  • Record income, expenses & non-cash transactions
  • Customize list of accounts and create additional expense accounts
  • Sales tax calculation & reporting
  • Accommodates multiple bank accounts and petty cash transactions
  • Automated tax invoice
  • 12 Month reporting period based on a user defined start date
  • Accommodates any year end period
  • Automated trial balance & bank reconciliation
  • Automated monthly & annual income statement & balance sheet
05 Excel Accounting Template - Trade Based
The only difference between this template and our Service Based Accounting template is that this template includes accounting for inventory, cost of sales and gross profit margins. Record income, stock purchases, expenses, monthly inventory balances and non-cash adjustments. Produces automated monthly & annual income statements, cash flow reports and a balance sheet. Use in conjunction with our Inventory Control templates.
  • Suitable for any business that trades in any type of inventory
  • Record income, stock purchases, expenses & non-cash transactions
  • Customize list of accounts and create additional expense accounts
  • Sales tax calculation & reporting
  • Accommodates multiple bank accounts and petty cash transactions
  • 12 Month reporting period based on user defined start date
  • Accommodates any year end period
  • Monthly review of turnover, cost of sales & gross profit margins
  • Automated trial balance & bank reconciliation
  • Automated monthly & annual income statement & balance sheet
06 Trial Balance Template
Compile a cumulative trial balance based on monthly account movements or compile a monthly trial balance based on cumulative account movements. Especially useful when required to consolidate cash flow forecast or budget data which usually consists of monthly balances for income statement accounts and cumulative balances for balance sheet accounts.
  • Suitable for any account number format
  • Compile a trial balance based on a cash flow forecast or budget
  • Compile a cumulative trial balance based on monthly account balances
  • Compile a monthly trial balance based on cumulative account balances
  • Easily switch between monthly & cumulative trial balances
  • Includes a 12 month reporting period
  • All trial balance calculations are automated
07 Year End Adjustments Template
Record year end adjusting journals against any trial balance and automatically calculate all the final trial balance amounts. The template can be based on any account numbering convention and can contain an unlimited number of accounts and an unlimited number of journal entries.
  • Suitable for any trial balance & account number format
  • Copy trial balance data into template
  • Record all year end journal entries
  • Automated calculation of all journal totals per account number
  • Automated calculation of all final trial balance amounts
08 Budget Template
Compile a comprehensive monthly & annual budget from any trial balance regardless of the accounts structure. Reports are compiled by linking each account in the trial balance to a pre-defined reporting class code. The template produces automated income statements, cash flow statements and balance sheets which compare the budget to actual results for the current & prior year.
  • Comprehensive automated budget reports for the next financial year
  • Includes income statement, cash flow statement and balance sheet
  • Compares budget to current financial year and prior financial year results
  • Includes month-to-date & year-to-date analysis
  • Includes monthly income statement for analysis of monthly budget amounts
  • Accommodates any account structure and trial balance format
  • Link account codes to pre-defined financial statement reporting classes
  • Includes trial balance checking and import feature
  • Customizable for any type of business
09 Financial Analysis Template
Analyze & compare financial results for 3 annual periods. Include the appropriate annual trial balances and link each account to a reporting class. The template produces automated financial reports consisting of an income statement, cash flow statement and balance sheet and compares all amounts in terms of a difference in value and percentage.
  • Comprehensive automated financial statement analysis
  • Includes income statement, cash flow statement and balance sheet
  • Compares financial statements for 3 financial years
  • Accommodates any account structure and trial balance format
  • Link account codes to pre-defined financial statement reporting classes
  • Easy to roll forward or back and to add more years for comparison
  • Includes trial balance checking and import feature
  • Customizable for any type of business
10 Monthly Payroll Template
Our aim with this template is to provide a simple monthly payroll solution which is suitable for businesses with less than 50 employees and which includes sufficient flexibility to be an appropriate solution in most of the 100+ countries where we have customers. Comprehensive automated reports enable users to review the accuracy & completeness of monthly payroll data and to summarise data for accounting & payment purposes.
  • Designed for businesses with less than 50 employees
  • Flexible design for earnings, deductions & company contributions
  • Accommodates fringe benefits
  • Automated calculation of income tax & medical tax credits
  • Automated calculation of salary deductions & company contributions
  • Automated analysis of gross & net pay by employee or department
  • Automated pay slips
  • Automated reconciliation of payroll calculations & payments
11 Annual Leave Template
Control the annual leave entitlement of employees and calculate a provision for the annual leave liability. Calculate annual leave balances for any 12 month period and easily roll forward for the next 12 month period. The leave that is taken by each employee can simply be recorded and the template automatically calculates the leave days due for each employee and the overall outstanding leave liability.
  • Suitable for any business
  • Enter employee codes, names, monthly salaries and opening balances
  • Record all leave days taken and leave days paid
  • Automatically calculates leave accruals, leave days due & leave provision
  • Incorporates any user defined 12 month period
  • Simple roll forward for subsequent periods
  • Includes monthly leave days analysis
12 Sick Leave Template
Control the sick leave entitlement of employees and thereby analyse the attendance of employees. Calculates remaining sick leave days for any period based on the sick leave entitlement & sick leave cycle duration which is specified by the user. The template does not need to be rolled forward and automatically adjusts the sick leave cycles based on the review period which is specified.
  • Suitable for any business
  • Enter employee codes, names and sick leave opening balances
  • Record all sick leave days taken and reasons for absence
  • Automatically calculates sick leave days due based on any leave cycle
  • Calculations on a cumulative basis with automated cycle adjustment
  • Template never needs to be rolled forward!
  • Includes monthly analysis of sick leave taken
13 Leave Tracker Template
Track the leave that is applied for by all employees and ensure that there is always adequate staff in each department or for every defined role. Record leave applications on an individual employee basis and results are displayed visually on the Summary sheet. Weekends and public holidays are also indicated.
  • Suitable for any business
  • Enter employee codes, names and departments
  • Record all leave application dates
  • Automatically displays leave dates for each employee
  • Also displays weekends & public holidays (user defined)
  • Template can be rolled forward or back by changing a single date
  • Default 60 day review period can be extended or reduced
  • Unlimited leave date entries & one version for multiple financial periods
14 Invoice & Debtors Template - Service Based
Create automated quotations & tax invoices for services provided. The template also includes automated customer account statements, monthly calculations of sales, receipts & debtor balances and an automated age analysis for all customer accounts. The template is suitable for any service based business - the next template should be used for trade based businesses.
  • Suitable for any service based business
  • Record business & banking details, customer information and invoice details
  • Incorporates user defined sales tax calculations
  • Automated quotation (accommodates 20 lines per quotation)
  • Automated tax invoice (accommodates 20 lines per invoice)
  • Automated customer account statement (includes ageing)
  • Monthly sales, receipts & debtor balance calculations & charts
  • Age analysis per individual customer account or all customer accounts
  • Detailed customer account balance report (includes ageing)
  • Quotation, invoice & statement includes space for inserting your own artwork
15 Invoice & Debtors Template - Trade Based
Create automated quotations & tax invoices which contain stock codes. The template also includes automated customer account statements, monthly calculations of sales, receipts & debtor balances and an automated age analysis for all customer accounts. The template is suitable for any trade based business - the previous template should be used for service based businesses.
  • Suitable for any trade based business (incorporates stock codes)
  • Record business details, customer information, stock details & invoice details
  • Incorporates user defined sales tax calculations
  • Automated quotation (accommodates 20 lines per quotation)
  • Automated tax invoice (accommodates 20 lines per invoice)
  • Automated customer account statement (includes ageing)
  • Monthly sales, receipts & debtor balance calculations & charts
  • Age analysis per individual customer account or all customer accounts
  • Detailed customer account balance report (includes ageing)
  • Quotation, invoice & statement includes space for inserting your own artwork
16 Invoice Age Analysis Calculation Template
Compile an age analysis for any invoice listing. The age analysis is compiled based on a user defined statement date and users can include all customer accounts or enter a specific customer account reference to produce an age analysis for a single customer. Ageing can be based on calendar months or on a specific day of the month.
  • Suitable for any business
  • Invoice listing sheet is fully customizable for ease of use
  • User defined statement date & 360 day monthly ageing
  • Accommodates month end and day of month ageing calculations
  • Age analysis for all customers or a single customer account
17 Purchase Order & Supplier Payments Template
Create automated purchase orders, payment remittances & supplier account statements. The template also creates automated reports including a 12 month purchases review, age analysis for individual or all supplier accounts, supplier account balances and a supplier payment forecast. The template can be used for both stock based and service based suppliers.
  • Suitable for any business
  • Record business details, supplier information, purchase order & invoice details
  • Incorporates user defined tax calculations
  • Automated purchase order (accommodates 25 lines per order)
  • Automated payment reimttance (accommodates 30 lines per remittance)
  • Automated supplier account statement (includes ageing)
  • Monthly purchases, payments & creditor balance calculations & charts
  • Age analysis per individual supplier account or all supplier accounts
  • Detailed supplier account balance report (includes ageing)
  • Automated supplier payment forecast
Show List