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!
  • Purchase a full template package in order to download ALL 50+ 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 50+ of our templates for only ZAR2,400!
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 with any account 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 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 monthly
  • Includes trial balance checking and import feature
  • Customizable for any type of business
03 Basic Accounting Template
This innovative accounting template enables users to record income & expenses and automatically produces a trial balance, income statement, cash flow statement and balance sheet. The template is easy to use and can be customized by editing the default accounts and adding an unlimited number of additional accounts. It also accommodates sales tax calculations and multiple bank accounts.
  • Suitable for any business
  • Record income & expenses
  • Customize list of accounts and create additional accounts
  • Automated sales tax calculation & reporting
  • Accommodates multiple bank accounts
  • 12 Month reporting period based on a user defined report date
  • Accommodates any year-end period
  • Monthly income statement, cash flow statement & balance sheet
  • Easy to roll forward for next financial year
04 Excel Accounting Template - Service Based
Record income & expenses and the template automatically produces a trial balance, income statement, cash flow statement and balance sheet. Includes an automated invoice, customer statement and customer age analysis. Unlimited number of accounts, automated sales tax calculations and multiple bank accounts. Roll the template forward for subsequent financial years by changing the year in a single cell.
  • Suitable for any service based business
  • Record income & expenses
  • Customize accounts & create unlimited additional accounts
  • Automated sales tax calculations & multiple bank accounts
  • Accommodates general ledger journals
  • Automated tax invoice & customer statements
  • 12 Month reporting period based on a user defined reporting year
  • Accommodates any year-end period
  • Monthly income statement, cash flow statement & balance sheet
  • Easy to roll forward for next financial year
05 Excel Accounting Template - Trade Based
Record income & expenses and template produces a trial balance, income statement, cash flow statement and balance sheet. Includes automated calculations of gross profit amounts & percentages, inventory on hand, invoices, customer statements and customer ageing. Accommodates unlimited accounts, sales tax calculations and multiple bank accounts. Easy to roll forward for subsequent financial years.
  • Suitable for any trade based business
  • Record sales, other income, stock purchases & other expenses
  • Accommodates general ledger journal entries
  • Sales tax calculations & multiple bank accounts
  • Unlimited stock codes & automated stock calculations
  • 12 Month reporting period based on any reporting year
  • Accommodates any year-end period
  • Monthly review of turnover, cost of sales & gross profit margins
  • Monthly income statement, cash flow statement & balance sheet
  • Easy to roll forward for subsequent financial years
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 & balance sheet
  • Compares budget to current & 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 & trial balance format
  • Link account codes to pre-defined financial statement reporting classes
  • Includes trial balance checking & 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 analyze 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 remittance (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