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 UI Text Box |
---|
| 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. UI Text Box |
---|
| 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. |
UI Expand |
---|
| Accounts reports | 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] | | Balance Sheet | Balance Sheet [Multi-Period Budget] | balshtbs | Balance Sheet | Balance Sheet [Last Year Analysis] | balshtla | Balance Sheet | Balance Sheet [Budget Analysis] | balshtba | | | pl | Profit & Loss | Profit & Loss [Cash] | | | Profit & Loss [Multi-Period] | pls | | Profit & Loss [Multi-Period Budget] | plbs | | Profit & Loss [With Year to Date] | plytd | | Profit & Loss [With Last Year] | plly | | Profit & Loss [% Sales Analysis] | plsa | | Profit & Loss [Last Year Analysis] | pllya | | Profit & Loss [Budget Analysis] | plba | Small Business Entity (Australia only) | Account Transactions [Cash] | acctcash | Small Business Entity (Australia only) | | 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 | | ppexcept | Exceptions | Deposit Transactions [Orders] | dpsexcept | | | genjrl | Jobs | | jobacts | Jobs | | jobactd | Jobs | | 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 | | Category Activity [Detail] | catactd | | Category Transactions [Accrual] | cattrans | | | catelist | | | catpl | | | catbs | Categories (Not Basics) | Category General Ledger [Summary] | | | Category General Ledger [Detail] | cattbsd | | | | Security and Audit | Session Security Audit | | Recurring Transactions | Recurring General Journal Entries | | Recurring Transactions | Recurring Transfer Money | | Recurring Transactions | Recurring Transaction List | |
|
UI Expand |
---|
| Banking reports | Report | Template Name (xlt) |
---|
| | chkbkreg | | | depslip | | | undepfnd | | Electronic Payments Register | elpayreg | | Unprocessed Electronic Payments | unepay | | | reconcil | | | cashflwstat | | Cash Disbursements Journal | cdjrnl | | | crjrnl | | | recchk | | | recdep | | Recurring Transaction List | rtlaccts | | To Do List [Recurring Transactions] | tdlrectn |
|
UI Expand |
---|
| GST/Tax reports | Report | Template Name (xlt) |
---|
GST Reports | Australia: GST [Summary - Accrual] New Zealand: GST [Summary - Invoice] | saltxsa | | Australia: GST [Summary - Cash] New Zealand: GST [Summary - Payments] | saltxsca | | Australia: GST [Detail - Accrual] New Zealand: GST [Detail - Invoice] | saltxd | | Australia: GST [Detail - Cash] New Zealand: GST [Detail - Payments] | saltxdc | | 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 |
|
UI Expand |
---|
| Sales reports | 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 | | salitms | Item | | salitmd | Item | | zsalit | Item | Analyse Sales [Item - FY Comparison] | | Item | Analyse Sales [Item Multi-Period] | | (Plus, Premier) | | salactd | (Plus, Premier) | | zsalac | (Plus, Premier) | Analyse Sales [Activity - FY Comparison] | | (Plus, Premier) | Analyse Sales [Activity Multi-Period] | | Customer | | salcusts | Customer | | | Customer | Sales History by Customer | salhiscu | 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 | | custldgr | (Not Basics) | Sales [Salesperson Summary] | salsps | (Not Basics) | Sales [Salesperson Detail] | salspd | (Not Basics) | Sales History by Salesperson | | (Not Basics) | Analyse Sales [Salesperson] | zsalsp | (Not Basics) | Customer Payments [Salesperson - FY Comparison] | | (Not Basics) | Customer Payments [Salesperson - Multi-Period] | | (Not Basics) | Customer Payments [Salesperson] | custpysp | | Sales Register Detail [All Sales] | srall | | | gisc | | | giss | | Invoice Transactions [Accrual] | invinq | | | inqsrc | | Sales & Receivables Journal | salejrnl | | Recurring Sales Transactions | recsale | | Recurring Transaction List | rtlaccts | | | tdlar | | To Do List [Recurring Sales] | tdlrcsal | | To Do List [Orders to be Shipped] | tdlordrs |
|
UI Expand |
---|
title | Time Billing reports (Plus, Premier) |
---|
| Time Billing reports (Plus, Premier) | Report | Template Name (xlt) |
---|
| | actlogdl | | | 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] | | Other Time Billing Reports | | actlist | Other Time Billing Reports (Australia only) | Unprocessed Activity Slips | unproaslips |
|
UI Expand |
---|
title | Purchases reports (Not Basics) |
---|
| Purchases reports (Not Basics) | Report | Template Name (xlt) |
---|
Payables | | agedaps | Payables | | 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 | | puritmd | Item | Analyse Purchases [Item Multi-Period] | | Supplier | Purchases [Supplier Summary] | purvends | Supplier | Purchases [Supplier Detail] | | Supplier | Analyse Purchases [Supplier] | zpurv | Supplier | Analyse Purchases [Supplier - FY Comparison] | | Supplier | Analyse Purchases [Supplier Multi-Period] | | Supplier | | vendldgr | | Purchase Register Detail [All Purchases] | prall | | Purchases Register [Open Item Receipts] | pritemr | Payments | | vdrpyh | Payments | | vdrpyt | | Bill Transactions [Accrual] | poinq | | Purchase History by Supplier | purhisv | | Purchases & Payables Journal | papjrnl | | Recurring Purchase Transactions | recpo | Recurring Transactions | Recurring Transactions List | rtlaccts | | | tdlap | | To Do List Recurring Purchases | tdlrecpr | | To Do List Expiring Discounts | tdlexpd | | To Do List Orders To Be Received | tdlordrs |
|
UI Expand |
---|
title | Payroll reports (Plus and Premier, Australia only) |
---|
| Payroll reports (Plus and Premier, Australia only) | Report | Template Name (xlt) |
---|
Employees | Payroll Activity [Summary] | payactsx | Employees | Payroll Activity [Detail] | paycatd | Employees | Employee Employment Details | | Employees | Payroll Register [Summary] | payregsx | Employees | Payroll Register [Detail] | payregd | Employees | | pradv | Employees | | timeshttb | Employees | | unproctstb | Superannuation | | supercat | Superannuation | | superafs | Superannuation | | superafd | Superannuation | | supereas | Superannuation | | superead | | | | | | | | Payroll Category Transactions | paycatiq | | | paysum | Entitlements | Entitlement Balance [Summary] | ebs | Entitlements | Entitlement Balance [Detail] | ebd | | Payroll Liabilities by Category | payliab | | Liabilities Payment Register | paylregdet | | | ptax | | Amount by Category (Payroll Tax) | ptaxcat | | | payjrnl | | | prrecurtran |
|
UI Expand |
---|
title | Inventory reports (Not Basics) |
---|
| Inventory reports (Not Basics) | Report | Template Name (xlt) |
---|
Items | | itmls | Items | | itmregs | Items | | itmregd | Items | | itminq | Items | Inventory Value Reconciliation | invrec | Items | Analyse Inventory Summary | | Items | | zinvd | Items | | autobld | Items | | invctst | Items | | | Pricing | | prclsst | Pricing | Price List [Detail] | | Pricing | Price Analysis | | | | invjrnl | | | tdlsa |
|
UI Expand |
---|
| Card File reports | Report | Template Name (xlt) |
---|
Cards | | cfsum | Cards | | | Cards | | addlst | Cards | | finq | Cards | | clog | Cards | Identifiers | ids | Cards | | giscf | | To Do List - Overdue Contracts | tdloc |
|
|