AcctVantage supports the ability to export financial reports to an XML file that is readable by Microsoft Excel®.

You can design financial reports using what are called tokens in place of GL account codes, account names, actual or budgeted dollar amounts and reporting periods. When the report is generated, AcctVantage replaces these tokens with the requested data and exports an XML file. You can include formatting, formulas, logos, etc. in the template as in any Excel® spreadsheet. At this time, only single worksheet XML files can be processed. In a multiple page workbook, pages after the first page will be ignored.

We will detail the token definitions below. When designing your financial report, you will use a token in place of the indicated value. If the token represents a range of GL accounts, AcctVantage will automatically expand it to include a row for each account within the range. Any formulas will be adjusted as necessary to accommodate the rows added for a range of accounts.

The Fiscal Period Setup area allows you to define your company’s fiscal year, or accounting period. Fiscal years are normally 365 days, but if your company is redefining when its year begins and ends, AcctVantage allows you to create a short year to bridge to the new start date.

AcctVantage does allow you to divide your fiscal year into any kind of periods you want, from calendar months to x number of days, although this would be extremely rare. You can even edit the date when each period begins or ends. The only restriction is that once you have entered a transaction for the year, you can no longer change the periods within it.

Note: Please contact AcctVantage Support if you plan on using Fiscal Periods that are a customized length (i.e. NOT the standard 12 months).