The Horizon Finance Budget Template is designed to capture both P&L (Income Statement) and Cash Flow budget data using a single upload file. This article explains each of the key fields within the template to help users complete it accurately.
Horizon allows granular budget planning, including multiple lines under a single GL Code, support for accrual logic, and optional metadata for enhanced reporting.
🔑 Key Fields in the Budget Template
| Field | Required | Description |
|---|---|---|
| GL Code | ✅ Yes | The Local GL Code from your accounting system. This code must already exist in your Entity Reporting Master Data. It determines where the budget line maps into financial statements. |
| Budget Line Description | ✅ Yes | A free text field used to break down budget items below GL Code level. For example, if the GL Code is Balance of Plant, the budget lines might be Civil Works, Weed Spraying, Electrical Works, etc. Multiple budget lines can map to a single GL Code. |
| Contact Name | ✅ Yes | Can be selected from your entity’s Contact List. This adds visibility into who owns or manages each line item. See related article: How do I create a new contact? |
| Accrued | ❌ Optional | For Full Service entities only, this field flags whether the budget line should be automatically accrued monthly. Leave blank for integrated entities. |
| Contracted | ❌ Optional | Also for Full Service entities only, this field indicates if the line item is contracted (e.g. governed by a PO or contract). Leave blank for integrated entities. |
💰 Budget Values
The remaining columns in the file correspond to monthly budget values. These should be formatted as standard numbers (no currency symbols or commas). You can populate:
P&L Budget values (e.g. salaries, maintenance costs)
Cash Budget values (e.g. bank payments or expected inflows)
Each monthly column represents a specific period in the entity’s financial year.
📅 Top Tip: Understanding Periods
Period 1 = First month of the entity’s financial year
-
For example:
If the year-end is June, then Period 1 = July, Period 2 = August, etc.
If the year-end is December, then Period 1 = January, Period 2 = February, and so on.
📎 Example
| GL Code | Budget Line Description | Contact Name | Accrued | Contracted | Period 1 | Period 2 | Period 3 |
|---|---|---|---|---|---|---|---|
| 6001 | Civil Works | John Smith | Yes | No | 5,000 | 5,000 | 5,000 |
| 6001 | Weed Spraying | Jane Doe | Yes | 1,200 | 1,200 | 1,200 |
🙋 Need Help?
If you're unsure how to complete or format your budget file, please use the Help > Contact Support option within Horizon Finance to reach our support team.
Comments
0 comments
Please sign in to leave a comment.