T-Ledger analyzer - Budget vs actual
The budget vs actual report will display the difference between the actual posted transaction totals and the budget (as entered) as a percentage for the selected period.
The "Budget vs actual" report will display the difference between the actual posted transaction totals and the budget (as entered) as a percentage for the selected period.
|
“Budget vs Actual” and “This year vs Last year” report may need to be Exported to a spreadsheet and then printed from the spreadsheet. If you click on the Print button, an error “Type conversion error 'Val':Expression TrpExpression46” will be produced when printing the “Budget vs Actual” and “This year vs Last year” report if transactions are posted (updated) to the ledger, e.g. HANDYMAN-B. These two reports can print on all Sets of Books which does not have any posted transactions, e.g. HANDYMAN, HANDYMAN-A. |
|
“Budget vs Actual” and “This year vs Last year” report may need to be Exported to a spreadsheet and then printed from the spreadsheet. This will create an “Export.txt” file which you may save with any name, to any location (file or folder) on your system. |
The "Budget vs actual" report will display the following:
1.Trial balance – The actual figures on the Trial balance - totals of transactions as posted (updated to the ledger) in batches (journals), sales documents (i.e. Invoices, Point-of-Sale Invoices and Credit notes) and purchase documents (i.e. Purchases and Supplier returns).
2.Budget – Once any budget figures are entered or edited (and saved), these figures will automatically be updated to the applicable accounts and will be available in the T-Ledger analyser and any reports which supports budget figures.
3.Difference – The difference amount actual trial Trial balance vs the Budget figures.
4.Percentage – The difference expressed as a percentage.
To print a budget vs actual report:
1.On the Reports ribbon, select T-Ledger analyser 1 or 2.
2.Select the “Budget vs actual” report type. This option is available for the Income / Expenses, Trial balance and Balance sheet report type.
3.To view the annual budget figures; select “Year” and the period from 2018/03/01 to 2019/02/28.
|
Select the period from 2018/03/01 to 2018/03/31 to view the budget figures for a specific period, e.g. “March 2018”. |
4.Click on the Report button to refresh and generate the budget figures.
|
To view the budget figures for sub-accounts, e.g. click on the + icon next to G210-000 Motor vehicle expenses. This will display the figures for each sub-account. |
5.If any of these budget figures need some adjustment, click on the Accounts (Action ribbon); select the applicable accounts and edit or enter the necessary figures.
6.Click on the Export button.
|
If you click on the Print button, an error “Type conversion error 'Val':Expression TrpExpression46” will be produced when printing the “Budget vs Actual” and “This year vs Last year” report if transactions are posted (updated) to the ledger, e.g. HANDYMAN-B. These two reports can print on all Sets of Books which does not have any posted transactions, e.g. HANDYMAN, HANDYMAN-A. |
|
If your system's default App for Spreadsheets, is configured correctly, it will open the file automatically in the default Spreadsheet App, e.g. Excel, OpenOfficeCalc, etc. In this example, Notepad, is the Default app for Comma Separated Value (*.csv) files.
|
This will create an “Export.txt” file which you may save with any name, to any location (file or folder) on your system.
Opening and printing the “Budget vs Actual” report in a Spreadsheet.
1.Locate the saved file, e.g. “Export.txt” file on your system and right-click.
2.Select “Open with...” and the Spreadsheet App.
3.The selected exported report file will be opened in the selected Spreadsheet, e.g. OpenOfficeCalc.
4.On the “Text Import” screen, the “Tab” option in the “Separated by” section should be selected.
5.The report file should display as follows:
6.You may wish to edit some formatting. In this case, the amount columns are aligned to the right.Set the print range and print the report.
An example of the printed exported "Budget vs actual" report, is as follows:
Created with the Personal Edition of HelpNDoc: Full-featured EBook editor
