Enter Nonprofit opening balances by fund
Import a Nonprofit trial balance coded by fund and net asset class, balanced within every fund, as one opening journal.
- Who can do this
- Owners, or people with Create journal entries and Post journal entries
- Where
- Books, then Import data
- You'll need
- Approved account mappings, an active Operating fund, and a fund code for every balance
On this page
Upload and post
- Open Books, then Import data.
- Under Your move, in order, find Opening balances and select Import.
- Select Download CSV template. The Nonprofit template includes the fund columns.
- Enter As-of date for the transition date.
- Drop the file on Drop your file here, or choose a file, or select that area to choose it.
- Select Upload and review.
- Fix every error, then select the Add button, which names what the file adds, such as Add 35 opening balances.
- Select View opening journal to inspect the posted entry.
Prepare the columns
| Column | Required | What to enter |
|---|---|---|
| Account Code | Yes | Code of an existing active account. |
| Debit | Yes | Nonnegative debit balance, or blank for a credit row. |
| Credit | Yes | Nonnegative credit balance, or blank for a debit row. |
| Fund Code | Yes | Code of an active fund. |
| Net Asset Class | For revenue, equity and expense rows | Without donor restrictions or with donor restrictions. |
| Function | No | Program services, management and general, or fundraising. |
An account can appear once for each fund, class and function, so the same cash account can open in two funds on two rows. Expense rows use the class without donor restrictions. An expense row with no function uses its account's approved default function, and is refused if the account has none.
How the review checks the file
The file must balance within every fund: each fund's debits must equal its credits. QixCount does not add a balancing Opening Balance Equity line for Nonprofit, so include your net asset accounts. A fund that doesn't balance is refused, with its rows listed.
Leave out Accounts Receivable and Accounts Payable. They come from open invoices and bills, which Nonprofit cannot import yet; contact support to plan them. Leave out Opening Balance Equity too.
The review also refuses the file until account mappings are approved and the Operating fund is active. Closed periods and Prevent backdating apply to the as-of date.
What happens next
WarningAdding the file posts one opening journal on the as-of date, with each line coded to its fund and class.
Only one active opening balances import is allowed. To replace it, undo the import: Undo reverses the opening journal on the as-of date with the same fund coding, then you can import a corrected file. Undo needs Reverse posted entries.
A linked bank's opening balance updates under the same rules as in General. Next, check your opening numbers.
Who can do this
Owners can import. Other active members need Create journal entries and Post journal entries. A file that sets a linked bank's opening balance also needs Edit bank transactions.