GL Account Upload

GL Account Upload creates new General Ledger accounts (code combinations) and updates existing ones in a ledger’s chart of accounts, from Excel. Download the accounts in a ledger (filtered by segment values if you like), add new accounts or edit the maintenance attributes of existing ones, then upload. Creating new accounts requires that your chart of accounts allows dynamic insertion of code combinations.

When to use it

• Mass-create new GL accounts (code combinations) in a chart of accounts that allows dynamic inserts.
• Enable or disable many existing accounts at once.
• Set or change Start Date Active / End Date Active across many accounts.
• Bulk-toggle Detail Posting Allowed or Detail Budgeting Allowed.
• Download a filtered list of existing accounts for review, then re-upload edits.

Before you start

• Blitz Report is installed and you are signed in to a General Ledger responsibility with access to the target ledger.
• To create new accounts, your chart of accounts must allow dynamic insertion of code combinations.
• The segment values you use already exist, are enabled and active, and are detail (not parent) values.

Step 1 – Choose a mode, set the parameters and download

In Blitz Report, open GL Account Upload and choose an Upload Mode:

• Create – an empty template for adding new accounts.
• Create, Update – downloads existing accounts so you can edit their maintenance attributes, and still lets you add new rows.

Run the upload to download and open the Excel file. Each row is automatically handled as a create or an update depending on whether the account already exists.

Step 2 – Enter or edit accounts

• New account – type the full account into Concatenated Segments; the individual segment columns and the Description fill in automatically.
• Maintenance attributes (apply to existing accounts, and settable on new ones): Enabled, Start Date Active, End Date Active, Detail Posting Allowed and Detail Budgeting Allowed.

Account Type and the Summary flag are set when the account is created and cannot be changed by this upload.

Step 3 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation – for new accounts, each segment value is checked against your chart of accounts. Correct anything it flags, and save the file.

Step 4 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates or updates each account directly. When it finishes, a result report opens showing each row as success or error.

What’s produced

• New and updated GL accounts (code combinations) in the chosen ledger’s chart of accounts.
• A result report listing every row with a status (success or error) and a message, re-displaying the stored account values so you can confirm what was created or changed.

Common questions

How does it know whether to create or update?
It matches the account’s concatenated segments against the existing accounts in the chart of accounts. A match is updated; no match is created. You do not set an action yourself.

Can I create accounts if my chart of accounts doesn’t allow dynamic inserts?
No. Creating a new code combination needs dynamic insertion enabled. If it is off, the account is validated but not created.

Can I delete or rename an account?
No. There is no delete, and the segments identify the account – changing them refers to a different account.

Why are the segment columns read-only?
They fill in automatically from the Concatenated Segments you type. Enter the full account string and the segments populate.

Why can’t I change Account Type or the Summary flag?
They are set when the account is created. Only Enabled, the active dates, and the Detail Posting and Detail Budgeting flags can be updated.

Troubleshooting