Accounts Tab

Reports and forms > OfficeLink > Modifying OfficeLink templates for Microsoft Excel >>

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

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 Realised Gain/Loss

curre.xlt

Currency Unrealised Gain/Loss

curunre.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

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

Session Report

session.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