Child pages
  • Microsoft Excel templates


 

 

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0
1
2
3
4
5
Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

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:

C:\Users\<Username>\Documents\MYOB\AccountRight\201x.x\Reports\Spreadsheet

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.

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 are exported from AccountRight, you can edit these templates.

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.

Accounts reports

Accounts reports

 

Category
ReportTemplate Name (xlt)
AccountsAccounts List [Summary] coasum 
Accounts Accounts List [Detail] coadet 
Accounts Account Transactions [Accrual] accting
AccountsAccount 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 & LossProfit & 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
JobsJob Profit & Loss Statementjobpl
JobsJob Reimbursable Expensesjobreexp
JobsJobs [Budget Analysis]jobba
JobsJobs Listjoblist
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 AuditSession Security Audit 
Recurring TransactionsRecurring General Journal Entries 
Recurring TransactionsRecurring Transfer Money 
Recurring TransactionsRecurring Transaction List  
Banking reports

Banking reports

 

Category
ReportTemplate 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
GST/Tax reports

GST/Tax reports

 

Category
ReportTemplate 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
Sales reports

Sales reports

 

Category
ReportTemplate 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
Time Billing reports (Plus, Premier)

Time Billing reports (Plus, Premier)

 

Category
ReportTemplate 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
ProductivityHourly Productivity [Summary] 
Productivity
Hourly Productivity [Detail]
hrprodd
Other Time Billing Reports
Activities List
actlist
Other Time Billing Reports (Australia only)
Unprocessed Activity Slips
unproaslips
Purchases reports (Not Basics)

Purchases reports (Not Basics)

 

Category
ReportTemplate 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
ItemPurchases [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
Payroll reports (Plus and Premier, Australia only)

Payroll reports (Plus and Premier, Australia only)

 

Category
ReportTemplate 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
Inventory reports (Not Basics)

Inventory reports (Not Basics)

 

Category
ReportTemplate 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
ItemsAnalyse 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
PricingPrice List [Detail]  
PricingPrice Analysis  
Transaction Journals
Inventory Journal
invjrnl
To Do List
To Do List Stock Alert
tdlsa
Card File reports

Card File reports

 

Category
ReportTemplate 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
CardsIdentifiersids
Cards
GIS Card File
giscf
To Do List
To Do List - Overdue Contracts
tdloc