Skip to main content

Downloading the budget by cost centre and account code (Accounting report)

How to download the standard accounting report per company from the budget report (amounts by cost centre, cost component and account code) on one sheet or monthly sheets, the accounting report notes (warnings and errors) and the allocation rules.

This article explains how to download the cost of a calculated budget plan to Excel, allocated to the cost centres and account codes defined in Teamso. Each row of the file is one cost component of one cost centre (gross salary, benefits and other gross pay, employer social security premium, employer unemployment insurance premium, other employer contributions, expenses), and the amount is booked on the account the cost centre defines for that item. The columns and the allocation rule are the same as in the payroll accounting report, so you can import the file into your accounting software as a budget.

Before you start

  • The plan's report must have been created (Creating and recalculating the budget report).

  • The plan must have started with Teamso data or an Excel file. Headcount plans have no accounting report.

  • Your company's cost centres and the account type or account number of their items must be defined on the Cost centre screen.

  • Employees' cost centres come from Teamso; for employees imported from Excel or added by hand you can enter the cost centre in the Employee details step (Check and edit employee details and add employees).

Step by step

  1. Open the plan and in the Report step press Accounting report among the report actions. The Accounting report window opens: "A standard accounting report is produced for each company; with several companies the files download in one zip."

  2. Choose the period grouping: All periods together (one sheet, the total of all months of the plan) or Monthly (one sheet per month, same columns).

    The accounting report window and notes
  3. If the plan has expense scenarios, choose with Include expenses whether expenses go into the file. The window opens with the report's expense setting.

  4. Read the Accounting report notes. Each note is a warning or an error and names the employee or the cost centre and the reason.

  5. If there are no errors, press Download. With one company the file "Company name, period.xlsx" downloads; with several companies one zip with all the files downloads.

  6. If the list has errors, the window shows The report could not be produced; fix the items below. and Download stays disabled. Fix the employee details or the cost centre definition in Teamso as the note suggests, then open the window again. Changing a cost centre does not change any amount, so you do not need to recalculate.

    Download is disabled while there are errors

Rules and limits

  • Allocation: each month's cost of an employee is split by the cost centre percentages, with the same rule as the payroll accounting report: two rows for the same cost centre count as one share, a row without a percentage counts as 100%, and percentages are not scaled up.

  • Account: each component is booked on the account defined in the cost centre for that component's item (for example Normal Mesai, İkramiye, SGK İşveren Primi, SGK İşsizlik İşveren Primi, TES İşveren Katkı Primi); a debit item comes before a credit item. A component without its own item is booked on the cost centre's salary account and a warning says so. Expenses are booked on the cost centre's salary account under their own name.

  • Totals: every monthly sheet equals the report's total cost of that month (with expenses when they are included) to the kuruş, and the single sheet equals the report's total. When rows are rounded, the remaining kuruş go to the rows with the largest remainders. The Check sheet shows, for every month, the report's total, the accounting report's total and the difference.

  • Errors (no file): the company has no cost centre; an employee from Teamso or Excel has no cost centre; an employee's cost centre does not exist in Teamso; the cost centre percentages do not add up to 100%; a cost centre has no account code.

  • Warnings (the file downloads): a manually added employee has no cost centre (the employee is left out of the file and the difference on the Check sheet is their cost); a component has no account of its own; only the employees you may see are included; employees that could not be calculated; the plan changed after the last calculation.

  • Company: an employee's company is the employer title in Teamso (the Company column in Excel). A manually added employee without a company goes to the company most of the plan's employees have.

  • Permissions and scope: the file is made of the employees you see in the report; amounts of employees from Teamso need the salary view permission and the branch scope. The report's filters do not apply to the accounting report.

  • Amounts come from the report's last calculation; cost centres are read from the plan's current employee details.

Common mistakes and FAQ

  • The Accounting report button is disabled: headcount plans have no accounting report.

  • "Your company has no cost centres.": add cost centres and the account codes of their items on the Cost centre screen.

  • "... the cost centre ... does not exist in Teamso.": the employee's cost centre code matches neither the code nor the name of a Teamso cost centre. Enter the right code in the Employee details step.

  • The Check sheet shows a difference: there are manually added employees left out because they have no cost centre; the difference closes once you enter their cost centre.

Related articles

Did this answer your question?