Post to General Ledger (GL)

Search for transactions using dates and transaction type filters to compose a list of distributions. Export the list of distributions to a .csv file to then be imported into accounting software, such as Financial Edge NXT. Finally, Mark transactions as Posted to exclude them from future searches.

Warning: Transactions marked as posted no longer appear in the Post To GL search results. Use view previous runs to review older runs with posted transactions.

To get started, navigate to Billing, Billing management, and select Post to GL.

  1. Select the statement period or date range to search for transactions that occurred within that range.

  2. Select from the following transactions to include them in your list of distributions:

    • All Charges or charges with Specific fees,

    • All Payments or Only payments from specific deposits, appear in list of distributions.

    • Enrollment deposits,

    • All Credits or Specific credits.

  3. Select Find transactions.

  4. Optional: Select Edit posting rules to modify the Journal reference field in the table.

    1. Enter the journal code.

    2. Select a drop-down for each transaction type to use that dropdown selection data in the Journal reference field.

      Tip: To add a First name and Last name to the Journal reference field for Charges with a space between the first and last name, select First name, then select <space> from the drop-down that appears below it. Finally, select Last name from the bottommost drop-down. Follow this pattern to for other transaction types.

    3. Optional: Select Preface the journal reference for each adjustment with this text to append text to the beginning of each Journal reference field for each transaction.

  5. Select Create CSV file to download the Distributions to post in the table above.

  6. Import the .csv file into your preferred accounting software.

  7. Once imported and accounted for, select Mark transactions as Posted. Transactions marked as posted can no longer be edited.

Billing clerks using Financial Edge NXT to manage their general ledger can use the Journal Entry Batch Creator add-in for Microsoft Excel to import their data from Billing management into Financial Edge NXT. More information about the add-in is found here.

Importing a Billing management-derived list of distributions into Financial Edge NXT process requires Billing clerks to:

  1. Authorize use of the Journal Entry Batch Creator add-in in Blackbaud Financial Edge NXT.

  2. Install the Journal Entry Batch Creator add-in in Excel.

  3. Export your list of transactions from Billing management.

  4. Merge columns from the exported transactions worksheet into the worksheet created by the Journal Entry Batch Creator add-in.

For a more visual overview of these steps, click here to watch a video demonstration.