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 Checks	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

 

 

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
Aging Receivables Summary	agedars.xlt
Aging 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
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

 

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
Aging Payables Detail	agedapd.xlt
Aging 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
To Do List Expiring Discounts	tdlexpd.xlt
To Do List Payables	tdlap.xlt
To Do List Recurring Purchases	tdlrecpr.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

 

Payroll Tab

 

Report	Template File Name
940 Report	940.xlt
941 Report	941.xlt
Accrual Balance Summary	aclbals.xlt
Accrual Balance Detail	aclbald.xlt
Employee Payroll List	empyrlst.xlt
Payroll Activity Summary	payacts.xlt
Payroll Activity Detail	paycatd.xlt
Payroll Category Transactions	paycatiq.xlt
Payroll Earnings	pradv.xlt
Payroll Journal	payjrnl.xlt
Payroll Register Summary	payregs.xlt
Payroll Register Detail	payregd.xlt
Payroll Summary	paysum.xlt
Payroll Recurring Transactions	prrecurtran.xlt
Quarterly Tax Totals	qtrtt.xlt
Tax Detail [Employee]	txdetemp.xlt
Tax Liabilities	taxliab.xlt
Timesheets	timeshttb.xlt
Unprocessed Timesheets	unproctsbt.xlt

 

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
Contact Log	clog.xlt
Identifiers	ids.xlt
To Do List Overdue Contacts	tdloc.xlt

 

 

Top of page