Help center
Cost accounting & budgets

Enter a budget and compare it with actuals

1 min read Reports > Cost accounting and budgets > Budgets
Download as PDF

Here you enter a budget per account and month, then compare it with actuals.

How to

  1. « Edit the budget » tab: pick the year and scope.
  2. Pick « Import a file », « Start from last year's actuals » or « Enter by hand ».
  3. Click « Save the budget », or « Cancel changes » to go back to the saved budget.
  4. « Budget vs actual » tab: pick « Through end of », then « Export » (PDF or Excel).
Learn more

Actuals come from the general ledger: posted entries, excluding closing and carry-forward. Overruns also show in the anomaly alerts. Only a book administrator edits the budget.

Enter the budget

« Edit the budget » tab: pick the fiscal year and « Whole book » or an analytic section. « Add an account » (search by number or name), then an amount per month (Jan to Dec). An amount typed in the « Total (annual) » column is spread over the 12 months, rounding on the last month. Enter goes down a row, Tab moves to the next cell. The grid shows one half-year at a time (« Jan – Jun » or « Jul – Dec ») with full amounts; the other half is folded into one column giving its total: click it to open it. « Quarters » and « 12 months » are still there (an amount typed in a quarter is spread over its 3 months), and your choice is remembered. Type 250k for 250,000 or 1.5M for 1,500,000. Per row, in the « ⋯ » menu: « Copy to all months » copies the first filled month, and « +x % N-1 » takes last year's actuals with the chosen change; tick several rows: the « +x % LY on n row(s) » button shows in the toolbar to do it at once. « Add an account » is below the grid. Rows are grouped by class (Revenue 7, Expenses 6, other accounts) with a subtotal per class and the budgeted result; an added row stays at the bottom until you save. « Save the budget », below the grid; the « Unsaved changes » message reminds you what is still to save.

Paste from Excel

Copy rows in Excel (the account, then the 12 months in the grid's order, or the account and an annual amount) and paste them into the Account column: the grid fills in. A block of amounts alone is pasted into a month cell. Amounts with spaces, commas or « FCFA » are read. An account missing from the chart or an unreadable amount blocks nothing: a recommendation offers to create the standard SYSCOHADA account, the closest account of the chart, or to read the amount as 0. Approved fixes are traced with the original value when you save.

Axes and sections: company budget or section budget

An axis is a way to split your business (Project, Branch, Activity). A section is a value of that axis (Project A, Abidjan branch). Pick « Whole book » for the company budget, or a section for its own budget: the actuals compared then include only the amounts split onto that section. The « How it works » button next to the selector recalls this rule. The Cost accounting, Budgets and Projects tabs stay in the same area and keep the fiscal year and section you picked.

Cancel, delete a row or the budget

« Cancel changes » takes the grid back to the saved budget, after a confirmation: entries, pastes and rows added or deleted since the last save are lost. « Delete row » removes an account from the grid; it leaves the budget when you save. « Delete the fiscal year budget » (or « the section budget » when a section is picked), in the toolbar's « ⋯ » menu, erases every amount of that scope, after a confirmation. Other sections and entries are not touched, and the old amounts stay in the audit log with your name. If you leave the page with unsaved changes, you are asked to confirm.

Import a budget (Excel or CSV)

« Import a file » (or « Import » in the toolbar), then « Download the template »: Account, Label, Section, then one amount per month (Jan to Dec). Also read: one row per account and month (Account, Month, Amount) and an annual amount (Account, Amount), spread over 12 months with rounding on the last month. Months named or numbered (03, 2026-03) are calendar months; P01 to P12 are the fiscal year's months. If the columns are not recognised, set them in « Column mapping ». The check shows the recommendations (standard account to create, closest account, unknown section to skip or put on the page's scope, unreadable amount read as 0), negative amounts on 6 or 7 to check (kept as they are), then the totals before and after. Pick « Replace » (the fiscal year's budget on this scope becomes the file's) or « Add » (the amounts add up), then « Approve and import », at the bottom. The import is traced: your name, the file, the row counts and the original values corrected.

Start from actuals

« Start from last year's actuals » card (empty budget) or the toolbar: pick the source fiscal year (« Actuals 2025 ») and a change in %, then « Load the actuals » or « Load ». The rows shown are replaced: review, then save.

Compare with actuals

« Budget vs actual » tab: pick the « Through end of » month. Three indicators (Revenue class 7, Expenses class 6, Result) show actuals, budget and the variance in amount and %, in red only when unfavourable (revenue or result below budget, expenses above). The chart compares budget and actual (Result, Revenue or Expenses) as « Bars », « Lines » or « Cumulative » (cumulative to date, the most useful for tracking); your choice is remembered. Hovering shows budget, actual and variance. Months after « Through end of » show the budget only. The table, grouped by class with subtotals and the result, gives, per account, Budget to date, Actual to date, Variance, Variance % and Annual budget. « Print » for the management meeting, or « Export » to PDF or Excel: the file carries the company, book, fiscal year, section, period, generation date and your name.

A specific question?

The Comptia team is available Monday to Friday, reply within 4 business hours.

Contact support