Microsoft Excel templates
Microsoft Excel templates are available for each report. The following tables list the report names and the corresponding Excel template names.
Accounts Tab
Report
Template File Name
Account History [OfficeLink]
accthist.xlt
Account Transactions
accting.xlt
Balance Sheet
balsht.xlt
Balance Sheet Multi-Period Spreadsheet]
balshts.xlt
Balance Sheet Multi-Period Budget Spreadsheet
balshtbs.xlt
Balance Sheet Last Year Analysis
balshtla.xlt
Balance Sheet Budget Analysis
balshtba.xlt
Accounts List Summary
coasum.xlt
Accounts List Detail
coadet.xlt
Audit Trail
auditr.xlt
Categories Activity Summary
catacts.xlt
Categories Activity Detail
catactd.xlt
Category Transactions
cattrans.xlt
Categories Profit & Loss
catpls.xlt
Categories Balance Sheet
catbs.xlt
Categories Trial Balance Summary
cattbs.xlt
Categories Trial Balance Detail
cattbsd.xlt
Categories [OfficeLink]
cathis.xlt
Categories List
catelist.xlt
Currency List
curlst.xlt
Currency Realized Gain/Loss
curre.xlt
Currency Unrealized Gain/Loss
curunre.xlt
Deposit Transactions
dpsexcept.xlt
Future Dated Transactions
fdexcept.xlt
General Journal
genjrl.xlt
Inventory Value Reconciliation Exceptions
inexcept.xlt
Job Activity Summary
jobacts.xlt
Job Activity Detail
jobactd.xlt
Job Budget History [OfficeLink]
jobbudhi.xlt
Job History [OfficeLink]
jobhist.xlt
Job Transactions
jobinq.xlt
Job Profit & Loss
jobpl.xlt
Job Reimbursable Expenses
jobreexp.xlt
Jobs [Budget Analysis]
jobba.xlt
Jobs List
joblist.xlt
Job Exception [Cash Transactions]
jobcashe.xlt
Job Exception [Invoice Transactions]
jobinvex.xlt
Linked Accounts
linkedact.xlt
Payables Reconciliation Exceptions
apexcept.xlt
Payroll Liabilities Reconciliation
praexcept.xlt
Prepaid Transactions
ppexcept.xlt
Profit & Loss
pl.xlt
Profit & Loss Multi-Period Spreadsheet
pls.xlt
Profit & Loss Multi-Period Budget Spreadsheet
plbs.xlt
Profit & Loss Year to Date
plytd.xlt
Profit & Loss Last Year
plly.xlt
Profit & Loss Percent Sales Analysis
plsa.xlt
Profit & Loss Last Year Analysis
pllya.xlt
Profit & Loss Budget Analysis
plba.xlt
Receivables Reconciliation Exceptions
arexcept.xlt
Recurring General Journal Entries
recgj.xlt
Recurring Transactions List
rtlaccts.xlt
Recurring Transfer Money Entries
rectm.xlt
Session Report
session.xlt
Transfer Money
rectm.xlt
Trial Balance Summary
trlbas.xlt
Trial Balance Detail
trlbald.xlt
Banking
Tab
Report
Template File Name
Cash Disbursements
cdjrnl.xlt
Cash Flow Analysis
cashflw.xlt
Cash Receipts
crjrnl.xlt
Bank Register
chkbkreg.xlt
Bank Deposit
bdr.xlt
Electronic Payments Register
epay.xlt
Reconciliation Report
reconcil.xlt
Recurring Cheques
recchk.xlt
Recurring Deposits
recdep.xlt
Recurring Transactions List
rtlbank.xlt
Statement of Cash Flow
cashflwstat.xlt
To Do List [Recurring Transactions]
tdlrectn.xlt
Undeposited Funds
undepfnd.xlt
Unprocessed Electronic Payments
unepay.xlt
Tab
Report
Template File Name
Sales Tab
Report
Template File Name
Activity Analyze Sales
zsalac.xlt
Activity Analyze Sales [FY Comparison]
zsalacly.xlt
Activity Analyze Sales [Spreadsheet]
zsalits.xlt
Activity Sales Summary
salacts.xlt
Activity Sales Detail
salactd.xlt
Ageing Receivables Summary
agedars.xlt
Ageing Receivables Detail
agedard.xlt
Customer Analyze Sales
zsalc.xlt
Customer Analyze Sales [FY Comparison]
zsalcly.xlt
Customer Analyze Sales [Spreadsheet]
zsalcs.xlt
Customer Ledger
custldgr.xlt
Customer Sales Summary
salcusts.xlt
Customer Sales Detail
salcustd.xlt
Customer Sales History [OfficeLink]
salhiscu.xlt
Customer Payments [Closed Invoices]
custpyh.xlt
Customer Payments [Salesperson]
custpysp.xlt
Customer Reimbursable Expenses
custrexp.xlt
Invoice Transactions
invinq.xlt
Item Analyze Sales
zsalit.xlt
Item Analyze Sales [FY Comparison]
zsalitly.xlt
Item Analyze Sales [Spreadsheet]
zsalits.xlt
Item Sales Summary
salitms.xlt
Item Sales Detail
salitmd.xlt
Progressive Billing Transactions
prgbillt.xlt
Receivables Reconciliation Summary
arrecsum.xlt
Receivables Reconciliation Detail
arrecdtl.xlt
Receivables with Tax
sumwtax.xlt
Recurring Sales Transactions
recsale.xlt
Recurring Transactions List
rtlsale.xlt
Referral Source
inqsrc.xlt
Sales
& Receivables Journal
salejrnl.xlt
Salesperson Analyze Sales
zsalsp.xlt
Salesperson Analyze Sales [FY Comparison]
zsalsply.xlt
Salesperson Analyze Sales [Spreadsheet]
zsalsps.xlt
Salesperson Sales History [OfficeLink]
salhissp.xlt
Salesperson Sales Summary
salsps.xlt
Salesperson Sales Detail
salspd.xlt
Sales Register All Sales
srall.xlt
Sales Register Closed Invoices
srclol.xlt
Sales Register Open Invoices and Orders
srinvor.xlt
Sales Register Quotes
srquo.xlt
Sales Register Returns and Credits
srcred.xlt
Sales Tax Summary
saltxs.xlt
Sales Tax Summary (Cash)
saltxsc.xlt
Sales Tax
saltxd.xlt
Sales Tax Detail (Cash)
saltxdc.xlt
Tax Amount Variance
tamvar.xlt
Tax Code List
txcodlst.xlt
To Do List [Receivables]
tdlar.xlt
To Do List [Recurring Sales]
tdlrcsal.xlt
To Do List [Orders to be Shipped & Received]
tdlordrs.xlt
GIS Customers
gisc.xlt
GIS Sales
giss.xlt
Time Billing Tab
Report
Template File Name
Activities List
actlist.xlt
Activity Log Detail Report
actlogdl.xlt
Activity Log Diary Report
actlogdy.xlt
Activity Slip Detail
asactdet.xlt
Activity Slip Summary
asactsum.xlt
Customer Slip Detail
ascusdet.xlt
Customer Slip Summary
ascussum.xlt
Employee Slip Detail
asempdet.xlt
Employee Slip Summary
asempsum.xlt
Job Slip Summary
asjobsum.xlt
Job Slip Detail
asjobdet.xlt
Productivity Hourly Detail
hrprodd.xlt
Productivity Hourly Summary
hrprods.xlt
Rate Exceptions
rateexcp.xlt
Unprocessed Activity Slips
unproaslips.xlt
Purchases Tab
Report
Template File Name
Ageing Payables Detail
agedapd.xlt
Ageing Payables Summary
agedaps.xlt
Bill Transactions
poinq.xlt
Item Analyze Purchases Spreadsheet
zpurits.xlt
Item Purchases Detail
puritmd.xlt
Item Purchases Summary]
puritms.xlt
Payables Reconciliation [Detail]
aprecond.xlt
Payables Reconciliation [Summary]
aprecons.xlt
Payables with Tax
sumwtax.xlt
Purchase History by Vendor [OfficeLink]
purhisv.xlt
Purchases
& Payables Journal
papjrnl.xlt
Purchases Register All Purchases
prall.xlt
Purchases Register Closed Bills
prclol.xlt
Purchases Register Open Bills and Orders
prbilor.xlt
Purchases Register Quotes
prquo.xlt
Purchases Register Returns and Debits
prcred.xlt
Recurring Purchase Transactions
recpo.xlt
Recurring Transactions List
rtlpurch.xlt
Vendor Analyze Purchases [FY Comparison]
zpurvly.xlt
Vendor Analyze Purchases [Spreadsheet]
zpurvs.xlt
Vendor Analyze Purchases
zpurv.xlt
Vendor Payment History
vdrpyh.xlt
Vendor Ledger
vendldgr.xlt
Vendor Payments
vdrpyt.xlt
Vendor Purchases Detail
purvendd.xlt
Vendor Purchases Summary
purvends.xlt
To Do List Expiring Discounts
tdlexpd.xlt
To Do List Payables
tdlap.xlt
To Do List Recurring Purchases
tdlrecpr.xlt
Payroll Tab
Inventory
Tab
Report
Template File Name
Analyze Inventory Summary
zinvs.xlt
Analyze Inventory Detail
zinvd.xlt
Auto-Build
autobld.xlt
Inventory Count Sheet
invctst.xlt
Inventory Journal
invjrnl.xlt
Inventory Value Reconciliation
invrec.xlt
Item Movement
itemmove.xlt
Item Sales History [OfficeLink]
itemsalh.xlt
Items List Summary
itmls.xlt
Items List Detail
itmld.xlt
Items Locations Summary
locnsumm.xlt
Items Register Summary
itmregs.xlt
Items Register Detail
itmregd.xlt
Item Transactions
itminq.xlt
Locations List
locnlist.xlt
Price Analysis
pricez.xlt
Price
Summary
prclsst.xlt
Price Detail
prclsstd.xlt
To Do List Stock Alert
tdlsa.xlt
Card
File Tab
Report
Template File Name
Addresses
addlst.xlt
Card List Summary
cfsum.xlt
Card List Detail
cfdet.xlt
Card Transactions
cfinq.xlt
Log
clog.xlt
Identifiers
ids.xlt
To Do List Overdue
tdloc.xlt
GIS Card File
giscf.xlt
Top of page