Microsoft Excel templates

When exporting a report to Microsoft Excel, AccountRight uses its own Microsoft Excel templates to format and lay out the report. The templates are saved in the following location:

If you use	located here
AccountRight PC Edition	2020.4 and earlier: C:\Users\ <user.name>\Documents\MYOB\AccountRight\Reports\Spreadsheet\20xx.x 2021.1 onwards: C:\Users\<user.name>\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet
AccountRight Server Edition	C:\Users\Public\Documents\MYOB\AccountRight\Reports\Spreadsheet\20xx.x

If you use

located here

AccountRight PC Edition

2020.4 and earlier:
C:\Users\ <user.name>\Documents\MYOB\AccountRight\Reports\Spreadsheet\20xx.x

2021.1 onwards:
C:\Users\<user.name>\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet

AccountRight Server Edition

C:\Users\Public\Documents\MYOB\AccountRight\Reports\Spreadsheet\20xx.x

20xx.x refers to the version number, for example: 2020.4.

When you install an AccountRight update, you'll need to copy the spreadsheets you've edited to the updated version's Spreadsheet folder to keep using them in the new version. With the release of automatic updates in AccountRight 2021.1, you now only have to move them one more time – see the FAQ below for details.

The following tables list the MYOB report names and the corresponding Excel template names you'll find in the Spreadsheet folder. If you want to change how the reports look when they're exported from AccountRight, you can edit these templates. You might do this to change the font style, colour or size, or to add a business logo. Just double-click a template to open it in Excel. Be aware that you shouldn't change the data fields in these templates or the template won't work as intended. A data field displays in double square brackets [[ ]] when viewing the template in Excel.

Caution: Editing and replacing templates

Editing these Excel templates requires an advanced understanding of how xlt templates work. You should make a copy of the templates before you edit them. If you don't have a copy of the templates to revert to, you'll need to uninstall then reinstall AccountRight to restore the default set of templates. Be aware that this will replace all edited templates.

Category	Report	Template Name (xlt)
Accounts	Accounts List [Summary]	coasum
Accounts	Accounts List [Detail]	coadet
Accounts	Account Transactions [Accrual]	accting
Accounts	Account Transactions [Cash]
Accounts	Account History	acchist
Accounts	General Ledger [Summary]	genjrls
Accounts	General Ledger [Detail]	genjrld
Accounts	Trial Balance	tribal
Accounts	Linked Accounts	linkedact
Balance Sheet	Balance Sheet	balsht
Balance Sheet	Balance Sheet [Multi-Period]	balshts
Balance Sheet	Balance Sheet [Multi-Period Budget]	balshtbs
Balance Sheet	Balance Sheet [Last Year Analysis]	balshtla
Balance Sheet	Balance Sheet [Budget Analysis]	balshtba
Profit & Loss	Profit & Loss Statement	pl
Profit & Loss	Profit & Loss [Cash]
Profit & Loss	Profit & Loss [Multi-Period]	pls
Profit & Loss	Profit & Loss [Multi-Period Budget]	plbs
Profit & Loss	Profit & Loss [With Year to Date]	plytd
Profit & Loss	Profit & Loss [With Last Year]	plly
Profit & Loss	Profit & Loss [% Sales Analysis]	plsa
Profit & Loss	Profit & Loss [Last Year Analysis]	pllya
Profit & Loss	Profit & Loss [Budget Analysis]	plba
Small Business Entity (Australia only)	Account Transactions [Cash]	acctcash
Small Business Entity (Australia only)	Profit & Loss [Cash]	plc
Exceptions	Payables Reconciliation Exceptions	apexcept
Exceptions	Receivables Reconciliation Exceptions	arexcept
Exceptions (Plus and Premier, Australia only)	Payroll Liabilities Reconciliation Exceptions	praexcept
Exceptions	Australia: Tax Code Reconciliation Exceptions New Zealand: GST Code Reconciliation Exceptions	tcre
Exceptions	Future Dated Transactions	fdexcept
Exceptions	Prepaid Transactions	ppexcept
Exceptions	Deposit Transactions [Orders]	dpsexcept
Transactions Journals	General Journal	genjrl
Jobs	Job Activity [Summary]	jobacts
Jobs	Job Activity [Detail]	jobactd
Jobs	Job Budget History	asjobdet
Jobs	Job Transactions [Accrual]	jobinq
Jobs	Job Exceptions [Cash Transactions]	jobcashe
Jobs	Job Exceptions [Invoice Transactions]	jobinvex
Jobs	Job Profit & Loss Statement	jobpl
Jobs	Job Reimbursable Expenses	jobreexp
Jobs	Jobs [Budget Analysis]	jobba
Jobs	Jobs List	joblist
Categories (Not Basics)	Category Activity [Detail]	catactd
Categories (Not Basics)	Category Transactions [Accrual]	cattrans
Categories (Not Basics)	Categories List	catelist
Categories (Not Basics)	Category Profit & Loss	catpl
Categories (Not Basics)	Category Balance Sheet	catbs
Categories (Not Basics)	Category General Ledger [Summary]
Categories (Not Basics)	Category General Ledger [Detail]	cattbsd
Security and Audit	Journal Security Audit	(no template)
Security and Audit	Session Security Audit
Recurring Transactions	Recurring General Journal Entries
Recurring Transactions	Recurring Transfer Money
Recurring Transactions	Recurring Transaction List

Category	Report	Template Name (xlt)
Cheques and Deposits	Bank Register	chkbkreg
Cheques and Deposits	Bank Deposit Slip	depslip
Cheques and Deposits	Undeposited Funds	undepfnd
Cheques and Deposits	Electronic Payments Register	elpayreg
Cheques and Deposits	Unprocessed Electronic Payments	unepay
Cheques and Deposits	Reconciliation Report	reconcil
Cheques and Deposits	Statement of Cash Flow	cashflwstat
Transaction Journals	Cash Disbursements Journal	cdjrnl
Transaction Journals	Cash Receipts Journal	crjrnl
Cash Receipts Journal	Recurring Cheques	recchk
Cash Receipts Journal	Recurring Deposits	recdep
Cash Receipts Journal	Recurring Transaction List	rtlaccts
To Do List	To Do List [Recurring Transactions]	tdlrectn

Category	Report	Template Name (xlt)
GST Reports	Australia: GST [Summary - Accrual] New Zealand: GST [Summary - Invoice]	saltxsa
GST Reports	Australia: GST [Summary - Cash] New Zealand: GST [Summary - Payments]	saltxsca
GST Reports	Australia: GST [Detail - Accrual] New Zealand: GST [Detail - Invoice]	saltxd
GST Reports	Australia: GST [Detail - Cash] New Zealand: GST [Detail - Payments]	saltxdc
GST Reports	Australia: Tax Amount Variance New Zealand: GST Amount Variance	tamvar
Tax Code Reports	Australia: Transaction Tax Codes New Zealand: Transaction GST Codes	ttxcds
Tax Code Reports	Australia: Tax Code Exceptions [Cash Transactions] New Zealand: GST Code Exceptions [Cash Transactions]	tcect
Tax Code Reports	Australia: Tax Code Exceptions [Invoice Transactions] New Zealand: GST Code Exceptions [Invoice Transactions]	tceit
Tax Code Reports	Australia: Tax Code List New Zealand: GST Code List	txcodlst
Reconciliation Reports	Australia: Tax Information Reconciliation [Summary] New Zealand: GST Information Reconciliation [Summary]	taxrecs
Reconciliation Reports	Australia: Tax Information Reconciliation [Detail] New Zealand: GST Information Reconciliation [Detail]	taxrecd

Category	Report	Template Name (xlt)
Receivables	Ageing Receivables [Summary]	agedars
Receivables	Ageing Receivables [Detail]	agedard
Receivables	Receivables Reconciliation [Summary]	aprecons
Receivables	Receivables Reconciliation [Detail]	aprecond
Receivables	Australia: Receivables with Tax New Zealand: Receivables with GST	sumwtax
Item	Sales [Item Summary]	salitms
Item	Sales [Item Detail]	salitmd
Item	Analyse Sales [Item]	zsalit
Item	Analyse Sales [Item - FY Comparison]
Item	Analyse Sales [Item Multi-Period]
Activity (Plus, Premier)	Sales [Activity Detail]	salactd
Activity (Plus, Premier)	Analyse Sales [Activity]	zsalac
Activity (Plus, Premier)	Analyse Sales [Activity - FY Comparison]
Activity (Plus, Premier)	Analyse Sales [Activity Multi-Period]
Customer	Sales [Customer Summary]	salcusts
Customer	Sales [Customer Detail]	salcustd
Customer	Sales History by Customer	salhiscu
Customer	Analyse Sales [Customer]	zsalc
Customer	Analyse Sales [Customer - FY Comparison]	zsalcly
Customer	Analyse Sales [Customer Multi-Period]	zsalcs
Customer	Customer Payments [Closed Invoices]	custpyh
Customer	Customer Reimbursable Expenses	custrexp
Customer	Customer Ledger	custldgr
Salesperson (Not Basics)	Sales [Salesperson Summary]	salsps
Salesperson (Not Basics)	Sales [Salesperson Detail]	salspd
Salesperson (Not Basics)	Sales History by Salesperson	salhissp
Salesperson (Not Basics)	Analyse Sales [Salesperson]	zsalsp
Salesperson (Not Basics)	Customer Payments [Salesperson - FY Comparison]
Salesperson (Not Basics)	Customer Payments [Salesperson - Multi-Period]
Salesperson (Not Basics)	Customer Payments [Salesperson]	custpysp
Sales Register	Sales Register Detail [All Sales]	srall
Other Sales Reports	GIS Customers	gisc
Other Sales Reports	GIS Sales	giss
Other Sales Reports	Invoice Transactions [Accrual]	invinq
Other Sales Reports	Referral Source	inqsrc
Transaction Journals	Sales & Receivables Journal	salejrnl
Recurring Transactions	Recurring Sales Transactions	recsale
Recurring Transactions	Recurring Transaction List	rtlaccts
To Do List	To Do List [Receivables]	tdlar
To Do List	To Do List [Recurring Sales]	tdlrcsal
To Do List	To Do List [Orders to be Shipped]	tdlordrs

Category	Report	Template Name (xlt)
Activity Log	Detail Report	actlogdl
Activity Log	Diary Report	actlogdy
Activity	Activity Slip [Activity Detail]	asactdet
Customer	Activity Slip [Customer Summary]	ascussum
Customer	Activity Slip [Customer Detail]	ascusdet
Employee	Activity Slip [Employee Summary]	asempsum
Employee	Activity Slip [Employee Detail]	asdempdet
Job	Activity Slip [Job Summary]	asjobsum
Job	Activity Slip [Job Detail]	asjobdet
Productivity	Hourly Productivity [Summary]
Productivity	Hourly Productivity [Detail]	hrprodd
Other Time Billing Reports	Activities List	actlist
Other Time Billing Reports (Australia only)	Unprocessed Activity Slips	unproaslips

Category	Report	Template Name (xlt)
Payables	Aged Payables [Summary]	agedaps
Payables	Aged Payables [Detail]	agedapd
Payables	Payables Reconciliation [Summary]	aprecons
Payables	Payables Reconciliation [Detail]	aprecond
Payables	Australia: Payables with Tax New Zealand: Payables with GST	sumwtax
Item	Purchases [Item Summary]
Item	Purchases [Item Detail]	puritmd
Item	Analyse Purchases [Item Multi-Period]
Supplier	Purchases [Supplier Summary]	purvends
Supplier	Purchases [Supplier Detail]	purvendd
Supplier	Analyse Purchases [Supplier]	zpurv
Supplier	Analyse Purchases [Supplier - FY Comparison]
Supplier	Analyse Purchases [Supplier Multi-Period]
Supplier	Supplier Ledger	vendldgr
Purchase Register	Purchase Register Detail [All Purchases]	prall
Purchase Register	Purchases Register [Open Item Receipts]	pritemr
Payments	Supplier Payment History	vdrpyh
Payments	Supplier Payments	vdrpyt
Other Purchase Reports	Bill Transactions [Accrual]	poinq
Other Purchase Reports	Purchase History by Supplier	purhisv
Transaction Journals	Purchases & Payables Journal	papjrnl
Recurring Transactions	Recurring Purchase Transactions	recpo
Recurring Transactions	Recurring Transactions List	rtlaccts
To Do List	To Do List Payables	tdlap
To Do List	To Do List Recurring Purchases	tdlrecpr
To Do List	To Do List Expiring Discounts	tdlexpd
To Do List	To Do List Orders To Be Received	tdlordrs

Category	Report	Template Name (xlt)
Employees	Payroll Activity [Summary]	payactsx
Employees	Payroll Activity [Detail]	paycatd
Employees	Employee Employment Details	(no template)
Employees	Payroll Register [Summary]	payregsx
Employees	Payroll Register [Detail]	payregd
Employees	Payroll Advice	pradv
Employees	Timesheets	timeshttb
Employees	Unprocessed Timesheets	unproctstb
Superannuation	Accrual by Category	supercat
Superannuation	Accrual by Fund Summary	superafs
Superannuation	Accrual by Fund Detail	superafd
Superannuation	Employee Advice Summary	supereas
Superannuation	Employee Advice Detail	superead
Superannuation Payments	Payments by Employee	superpay1
Superannuation Payments	Payments by Fund	superpay2
Payroll Categories	Payroll Category Transactions	paycatiq
Payroll Categories	Payroll Summary	paysum
Entitlements	Entitlement Balance [Summary]	ebs
Entitlements	Entitlement Balance [Detail]	ebd
Payroll Liabilities	Payroll Liabilities by Category	payliab
Payroll Liabilities	Liabilities Payment Register	paylregdet
Payroll Tax	Payroll Tax	ptax
Payroll Tax	Amount by Category (Payroll Tax)	ptaxcat
Transaction Journals	Payroll Journal	payjrnl
Recurring Transactions	Standard Pay Details	prrecurtran

Category	Report	Template Name (xlt)
Items	Items List Summary	itmls
Items	Items Register Summary	itmregs
Items	Items Register Detail	itmregd
Items	Item Transactions	itminq
Items	Inventory Value Reconciliation	invrec
Items	Analyse Inventory Summary
Items	Analyse Inventory Detail	zinvd
Items	Auto-Build Items	autobld
Items	Inventory Count Sheet	invctst
Items	Item Sales History	itemsalh
Pricing	Price List [Summary]	prclsst
Pricing	Price List [Detail]
Pricing	Price Analysis
Transaction Journals	Inventory Journal	invjrnl
To Do List	To Do List Stock Alert	tdlsa

Category	Report	Template Name (xlt)
Cards	Card List Summary	cfsum
Cards	Card List Detail	(no template)
Cards	Address List	addlst
Cards	Card Transactions	finq
Cards	Contact Log	clog
Cards	Identifiers	ids
Cards	GIS Card File	giscf
To Do List	To Do List - Overdue Contracts	tdloc

FAQs

Customised Excel templates are stored at this location on your computer:

If you use	located here
AccountRight PC Edition	2020.4 and earlier: C:\Users\ <user.name>\Documents\MYOB\AccountRight\Reports\Spreadsheet\20xx.x 2021.1 onwards: C:\Users\ <user.name>\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet
AccountRight Server Edition	C:\Users\Public\Documents\MYOB\AccountRight\Reports\Spreadsheet\ 20xx.x

If you use

located here

AccountRight PC Edition

2020.4 and earlier: C:\Users\ <user.name>\Documents\MYOB\AccountRight\Reports\Spreadsheet\20xx.x

2021.1 onwards: C:\Users\ <user.name>\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet

AccountRight Server Edition

C:\Users\Public\Documents\MYOB\AccountRight\Reports\Spreadsheet\ 20xx.x

20xx.x refers to the version number, for example: 2020.4.

When you update AccountRight, you'll need to copy any customised Excel templates into the Reports folder for the new version.

For example, if you've updated from AccountRight 2020.4 to 2021.1, you'll need to copy edited templates (or the entire Reports folder) from here:

C:\Users\<user.name>\Documents\MYOB\AccountRight\Reports\Spreadsheet\2020.4

To here:

C:\Users\<user.name>\Documents\MYOB\AccountRight\Current\Reports

Unlike in previous AccountRight releases, with the release of automatic updates in AccountRight 2021.1, you'll only need to do this once. All future updates will preserve the edited templates in the new location.

Note that if there's a change to the default template in an AccountRight release this change will override your edited template – changing your edited template's name from the default template's name will stop this from happening. We'll let you know if any changes in future releases affect your edited templates.

Microsoft Excel templates

Accounts reports

Banking reports

GST/Tax reports

Sales reports

Time Billing reports (Plus, Premier)

Purchases reports (Not Basics)

Payroll reports (Plus and Premier, Australia only)

Inventory reports (Not Basics)

Card File reports

FAQs

Where are my customised Excel templates stored?