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
Creditors Reconciliation Exceptions	apexcept.xlt
Currency List ( AccountEdge Plus only)	curlst.xlt
Currency Realised Gain/Loss ( AccountEdge Plus only)	curre.xlt
Currency Unrealised Gain/Loss ( AccountEdge Plus only)	curunre.xlt
Debtors Reconciliation Exceptions	arexcept.xlt
Deposit Transactions	dpsexcept.xlt
Future Dated Transactions	fdexcept.xlt
Nominal Ledger [Summary]	genjrls.xlt
Nominal Ledger [Detail]	genjrld.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
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
Recurring Nominal Journal Entries	recgj.xlt
Recurring Transactions List	rtlaccts.xlt
Recurring Transfer Money Entries	rectm.xlt
Session Report	session.xlt
Stock Value Reconciliation Exceptions	inexcept.xlt
Transfer Money	rectm.xlt
Trial Balance	trlbal.xlt
VAT [Summary]	vats.xlt
VAT [Summary – Cash]	vatsc.xlt
VAT [Detail]	vatd.xlt
VAT [Detail – Cash]	vatdc.xlt
VAT Exceptions [Cash Transactions]	tcect.xlt
VAT Exceptions [Invoice Transactions]	tceit.xlt
VAT Return	vatrtn.xlt
VAT Return [Cash]	vatrtnc.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
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

 

VAT Tab

Report	Template File Name
VAT [Summary]	vats.xlt
VAT [Summary – Cash]	vatsc.xlt
VAT [Detail]	vatd.xlt
VAT [Detail – Cash]	vatdc.xlt
VAT Exceptions [Cash Transactions]	tcect.xlt
VAT Exceptions [Invoice Transactions]	tceit.xlt
VAT Return	vatrtn.xlt
VAT Return [Cash]	vatrtnc.xlt
VAT Code List	txcodlst.xlt

 

Sales Tab

Report	Template File Name
Activity Analyse Sales	zsalac.xlt
Activity Analyse Sales [FY Comparison]	zsalacly.xlt
Activity Analyse Sales [Spreadsheet]	zsalits.xlt
Activity Sales Summary	salacts.xlt
Activity Sales Detail	salactd.xlt
Ageing Debtors Summary	agedars.xlt
Ageing Debtors Detail	agedard.xlt
Customer Analyse Sales	zsalc.xlt
Customer Analyse Sales [FY Comparison]	zsalcly.xlt
Customer Analyse 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
Debtors Reconciliation Summary	arrecsum.xlt
Debtors Reconciliation Detail	arrecdtl.xlt
Debtors with VAT	sumwtax.xlt
EC Sales	eclist.xlt
Invoice Transactions	invinq.xlt
Item Analyse Sales	zsalit.xlt
Item Analyse Sales [FY Comparison]	zsalitly.xlt
Item Analyse Sales [Spreadsheet]	zsalits.xlt
Item Sales Summary	salitms.xlt
Item Sales Detail	salitmd.xlt
Recurring Sales Transactions	recsale.xlt
Recurring Transactions List	rtlsale.xlt
Referral Source	inqsrc.xlt
Sales Ledger Journal	salejrnl.xlt
Salesperson Analyse Sales	zsalsp.xlt
Salesperson Analyse Sales [FY Comparison]	zsalsply.xlt
Salesperson Analyse 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
VAT Amount Variance	tamvar.xlt
VAT Code List	txcodlst.xlt
To Do List [Debtors]	tdlar.xlt
To Do List [Recurring Sales]	tdlrcsal.xlt
To Do List [Orders to be Delivered & 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 Creditors Detail	agedapd.xlt
Ageing Creditors Summary	agedaps.xlt
Purchase Transactions	poinq.xlt
Creditors Reconciliation [Detail]	aprecond.xlt
Creditors Reconciliation [Summary]	aprecons.xlt
Creditors with VAT	sumwtax.xlt
Item Analyse Purchases Spreadsheet	zpurits.xlt
Item Purchases Detail	puritmd.xlt
Item Purchases Summary]	puritms.xlt
Purchase History by Supplier [OfficeLink]	purhisv.xlt
Purchases Ledger Journal	papjrnl.xlt
Purchases Register All Purchases	prall.xlt
Purchases Register Closed Purchases	prclol.xlt
Purchases Register Open Purchases 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
Supplier Analyse Purchases [FY Comparison]	zpurvly.xlt
Supplier Analyse Purchases [Spreadsheet]	zpurvs.xlt
Supplier Analyse Purchases	zpurv.xlt
Supplier Payment History	vdrpyh.xlt
Supplier Ledger	vendldgr.xlt
Supplier Payments	vdrpyt.xlt
Supplier Purchases Detail	purvendd.xlt
Supplier Purchases Summary	purvends.xlt
To Do List Expiring Discounts	tdlexpd.xlt
To Do List Creditors	tdlap.xlt
To Do List Recurring Purchases	tdlrecpr.xlt

 

Payroll Tab

AccountEdge Plus only

 

Report	Template File Name
Autopay Report	autop.xlt
BOBS Report	bobs.xlt
Employee Payroll List	empyrlst.xlt
Entitlement Balance [Detail]	empexpbd.xlt
Entitlement Balance [Summary]	empexpbs.xlt
Employer’s Payment Record (P32)	p32.xlt
P11 PAYE	p11paye.xlt
P11 NIC	p11nic.xlt
P35 Deductions Working Sheet	p35.xlt
P45 Details of employee leaving work	p45.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
Recurring Paycheques	recpychk.xlt
Timesheets	timeshttb.xlt
Unprocessed Timesheets	unproctsbt.xlt

 

Stock Tab

Report	Template File Name
Analyse Stock Summary	zinvs.xlt
Analyse Stock Detail	zinvd.xlt
Auto-Build	autobld.xlt
Item Movement ( AccountEdge Plus only)	itemmove.xlt
Item Sales History [OfficeLink]	itemsalh.xlt
Items List Summary	itmls.xlt
Items List Detail	itmld.xlt
Items Locations Summary ( AccountEdge Plus only)	locnsumm.xlt
Items Register Summary	itmregs.xlt
Items Register Detail	itmregd.xlt
Item Transactions	itminq.xlt
Locations List ( AccountEdge Plus only)	locnlist.xlt
Price Analysis	pricez.xlt
Price Summary	prclsst.xlt
Price Detail	prclsstd.xlt
Stock Count Sheet	invctst.xlt
Stock Journal	invjrnl.xlt
Stock Value Reconciliation	invrec.xlt
To Do List Stock Alert	tdlsa.xlt

 

Card Tab

Report	Template File Name
Addresses	addlst.xlt
Card List Summary	cfsum.xlt
Card List Detail	cfdet.xlt
Card Transactions	cfinq.xlt
Reminder Log	clog.xlt
Identifiers	ids.xlt
To Do List Overdue Reminders	tdloc.xlt
GIS Card File	giscf.xlt