Overview
Budgets in Xero are often overlooked as there is not a huge amount of support for them.
Forecasting with Budgets
Xero budget data is enriched so it can be used to support many more scenarios.
Daily Budget Amounts
Budget Amounts are calculated for each day based on the number of days in a month. This means you can have weekly budgets as well as monthly and/or track actual progress within the month against the budget.
Net, Gross and Tax Amounts
So that it is possible to use budgets to forecast tax amounts, Net amounts are assumed to be entered within the Budget in Xero and the Account Code for a Budget line is used to determine Tax and Gross amounts.
Reporting Currency Amounts
The Net, Tax and Gross amounts also have their respective Reporting Currency amounts calculated.
In this way, you can combine the budgets of multiple Xero organisations, even if they use different currencies.
Data Model
Field | Type | Notes |
Account Code | Text | The Account Code for the Budget. e.g. 200 |
Account Name | Text | The corresponding Account Name. e.g. Sales If want to report and link other sources of financial information (for example to link Journals and Invoices data to compare actuals and forecasts) then use the linked Account Name field from the Accounts table. |
Budget Date | Date | The Day of the budget. |
Budget Month End | Date | The corresponding Budget Month End Date. |
Budget Month Start | Date | And the corresponding Budget Month Start Date. |
Budget Name | Text |
|
Connection Name | Text | The name of the Connection. Typically the name of the Xero Organisation. |
Data current as of | Datetime | When the Data was taken from Xero. |
Gross Amount | Number | The Gross Amount (Net and Tax) in the base currency of the Xero Organisation. |
Gross Amount (RC) | Number | The Gross Amount (Net and Tax) in the reporting currency. |
Last Updated | Datetime |
|
Net Amount | Number | The Net Amount in the base currency of the Xero Organisation. |
Net Amount (RC) | Number | The Net Amount in the reporting currency. |
Notes | Text |
|
Status | Text | e.g. {'APPROVED'} |
Tax Amount | Number | The Tax Amount in the base currency of the Xero Organisation. |
Tax Amount (RC) | Number | The Tax Amount in the reporting currency. |
Tracking Category 0 | Text |
|
Tracking Category 1 | Text |
|
Tracking Option 0 | Text |
|
Tracking Option 1 | Text |
|
Type | Text | e.g. {'OVERALL'} |