60+ XL Excel Functions
Use our functions in your own management reports, simply open your own bespoke Reports created in a workbook and Excel will refresh data in seconds with accounting data synced daily.
Standard Functions:
- Company Information Get Name, Last Sync Date...
- GL Codes and Headings and Names Spill *
- GL Period Convert Year and Period
- GL Name Get GL names
- GL Turnover/Balance to Spill *
- GL Turnover/Balance or Credit/Debits for Period
- GL Budgets Get Budgets or just keep them in Excel
Pro Functions:
- Age Receivable/Payable + Predicted Age Analysis Spill *
- Get Cust/Vendor Turnover to Spill *
- Get Stock Qty/Turnover/Profit to Spill *
- Get Transactions/Journals to Spill *
- Get Customer/Vendor Info and Customer/Vendor Turnover
- Get Stock Item Info Info, Qty, Turnover/Profit analysis
- Get Currency Info Get Name, Rates...
* - Spill functions returns many Rows and Columns using one function.
