Reverse credits on GL balance imports

Reversing credits is a common way to ensure that balance information is presented consistently in reports, especially when reports need credit balances to always appear as positive or negative values.

When you select the Reverse Credits option, it changes how credit balances are imported into the system. This setting applies to the entire entity, meaning if affects all accounts in that entity during GL balance imports.

For accounts that usually have credit balances, such as liability and revenue accounts, the imported balance will be adjusted:

• Each credit balance is multiplied by -1 to reverse its sign

• As a result:

  • A negative credit balance will become positive.

  • A positive credit balance will become negative.

Import negative GL balances as credits

Settings are required at both the Entity and Account levels to reverse credits on importing.

1. Identify the accounts with negative balances in the source data.

2. Go to and click the Entities tab.

   • Select the Entity into which the accounts will be imported.

   • Select the Reverse Credits option. This ensures that negative values are converted to positive (credit) during import.

3. Click .

4. Proceed to and click the Accounts tab.

   • Choose an Account type corresponding to the one with a negative balance in your source data negative balance.

   • For Natural Balance, select Credit to reverse the value.

   • Click .

   • Repeat this step for all accounts with negative balances.

5. Go to the Import Balances tab to import the balances for the selected entity. For details, see the Import general ledger balance article. View the results after the import.

6. Verify the imported accounts. After a successful import, go to the Trial Balance tab to confirm that the accounts have been imported correctly. These accounts should now display as credits (without the negative sign).