---
title: "Action: Account budget"
description: "Imports account budgets, writing up to twelve period amounts onto each account for the configured budget periods."
url: https://support.sapera.io/en/articles/604-action-account-budget
collection: "SyncTool"
updated: 2026-09-25
language: en
alternates: [da]
---

# Action: Account budget

Imports account budgets, writing up to twelve period amounts onto each account for the configured budget periods.

Imports account budgets, writing up to twelve period amounts onto each account for the configured budget periods.

## How to use the action

1\. Select the action in the **Action** field. 2. Point to your data source – a **file** (CSV or Excel) or a **SQL query**. 3. Map the source columns to Sapera's fields in the column mapping (see _Source fields_ below). 4. Run **Compare** to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run **Update Sapera** to perform the import.

Use the **Allow create** and **Allow update** parameters to control whether new rows are created and whether existing ones are updated.

## How matching and updating works

Each row is matched on the **account** and writes budget amounts for it.

-   Up to **twelve period amounts** can be written per account. The budget periods the amounts go into are defined by the parameters StartDateOfPeriod01–StartDateOfPeriod12.
    
-   Only the accounts in your source are processed. Direction: from file/SQL into Sapera.
    

## Key parameters

<table data-id="78035ca5-08ca-4bf8-854b-db2e133eddf3" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="d98410b7-1196-45bd-a069-b6ddb4233135" style="text-align: left;"><strong>Parameter</strong></p></td><td colspan="1" rowspan="1"><p data-id="3e23ee1c-c45d-4407-9ecb-908cbce7fc3c" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="85231d14-76ca-4d16-9d93-d7d4c8a2ed4e" style="text-align: left;">AllowCreate</p></td><td colspan="1" rowspan="1"><p data-id="35c2e5b9-a56d-4d36-930a-7a3599ff7ff7" style="text-align: left;">When enabled, budget lines that do not already exist are created.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="6be51977-d49a-4655-bb79-458595f076df" style="text-align: left;">AllowUpdate</p></td><td colspan="1" rowspan="1"><p data-id="8066aeb0-c255-4d8f-9aa3-59f4467b2339" style="text-align: left;">When enabled, existing budget lines are updated with the values from the source.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="b72ae1ee-b7fb-4c39-ab44-7fb15edeb6db" style="text-align: left;">IsDelete</p></td><td colspan="1" rowspan="1"><p data-id="ba364bf3-3aee-4cd3-9d5b-b74a835c680d" style="text-align: left;">When enabled, the matched budget lines are deleted instead of imported.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="969bac85-3239-4258-b8b2-7e46658961ec" style="text-align: left;">StartDateOfPeriod</p></td><td colspan="1" rowspan="1"><p data-id="e8bed17d-2d49-4cab-af1b-a3430f0c12b8" style="text-align: left;">The start date of each budget period (StartDateOfPeriod01 through 12), mapping each amount column to its period.</p></td></tr></tbody></table>

## Source fields

<table data-id="90497535-a37a-4011-a601-b4b0ecf1b49e" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="8551b3a8-bb63-4b8a-896e-0a3c57e96587" style="text-align: left;"><strong>Field</strong></p></td><td colspan="1" rowspan="1"><p data-id="c9919207-cb19-47c3-9028-2dc4375aee21" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="4d2ac95e-4bfa-4840-b4ef-acab6d6d1c0c" style="text-align: left;">AccountNumber</p></td><td colspan="1" rowspan="1"><p data-id="2d283f6d-97fb-4bfa-807c-8c0ec1130bee" style="text-align: left;">The account number whose budget is set. This is the identifier column.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="780039eb-4605-4033-b7ef-d3d2a18cfa70" style="text-align: left;">Amount</p></td><td colspan="1" rowspan="1"><p data-id="b2562baf-b7f2-44d5-a3ae-f88fc2500d03" style="text-align: left;">The budgeted amount for the period (Amount01 through Amount12, one per budget period).</p></td></tr></tbody></table>

* * *

See also the overview [SyncTool – actions](https://support.sapera.io/en/articles/547-synctool-handlinger.md).

* * *

**Want to know more?**

Read more in these related articles:

[

Standard parameters for all actions

The general parameters available on most SyncTool actions: step control, error handling, timeout, etc.

](https://support.sapera.io/en/articles/648.md)
