Excel-Skills Australia

100% UNIQUE EXCEL TEMPLATES

Accounting Templates

This page lists all of our Excel Accounting templates. Use the links in the template list to view the templates that are included in the other template categories.

01 Financial Statements Template

Use our 100% unique financial statements template to compile comprehensive financial statements based on Australian Accounting Standards Reduced Disclosure Requirements (and the Corporations Act 2001) 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 Reduced Disclosure Requirements
  • 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

Use our monthly management accounts template to 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

We provide three accounting templates in Excel. This basic 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 GST calculations and multiple bank accounts.

  • Suitable for any business
  • Record income & expenses
  • Customize list of accounts and create additional accounts
  • Automated GST 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 Accounting - Service Based Template

Want to maintain accounts in Excel? We provide unique Excel templates for accounting! 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 GST 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 GST 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 Accounting - Trade Based Template

Use this accounting template to record income & expenses and the template produces a trial balance, trading profit and loss accounts, 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, GST 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
  • GST 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

Use this trial balance template to compile a cumulative trial balance based on monthly account movements or to 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

Use our year end adjustments template to 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

Use this Excel budget template to 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

Use this financials template to analyse & 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. You can also use the template as a financial projections template by including a forecast for the most recent financial year.

  • 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 Annual Leave Template

Use this annual leave calculator template to 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

11 Leave Tracker Template

This leave tracking template enables users to 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

12 Invoice & Debtors - Service Based Template

Use our invoice template in Excel to 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 GST 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

13 Invoice & Debtors - Trade Based Template

Use our trade based tax invoice template to 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 GST 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

14 Invoice Age Analysis Template

Compile an aging report in Excel 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

15 Purchases & Supplier Payments Template

Use this template for purchase order & payment tracking in Excel. 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