GL Exports

In Nimble AMS, all the details of financial transactions are recorded and organized in batches. Association typically have their own General Ledger (GL) system(s) where they track the organization's financial data, like transactions, as the comprehensive source of truth for all financial information. Nimble AMS GL Export functionality allows Associations to keep their financial data in sync between Nimble AMS and the GL system by providing a way to export financial transactions in groups from Nimble AMS which can then be imported into the GL system.

Nimble AMS staff users already have this ability to export transaction data via batches and import it into the GL system. With the enhanced GL Exports feature, Nimble AMS customers can use a single solution to export GL files from Nimble AMS in any of the three file formats (.csv, .txt, and .iif). You can easily set up exports in these formats with point and click configuration. This feature also provides you with pre-configured options to export GL files for the below standard GL systems:

  • Sage Intacct
  • QuickBooks Online
  • QuickBooks Desktop
  • Microsoft Dynamics Great Plains

This makes it even easier for associations to keep financial information in sync. Furthermore, it reduces set up time required and also gives greater flexibility should an association ever change their GL system in the future.

Benefits

  • Easy Configuration: Pre-configured options and an enhanced single solution reduce the setup time required and make it easier for transactions to be exported.
  • Point-and-Click Configuration: This type of configuration enables you to customize the columns to display on the GL file and the data for those columns.

  • Future-Use Flexibility: The availability of all three commonly used file formats (.csv, .txt., and .iif) in a single package enables you to change your GL system without compatibility issues with Nimble AMS.

Batch Export Configuration

You can export the financial transactions created in Nimble AMS to your general ledger (GL) in the format needed by your GL system. You create a batch export configuration record for the format you require. The Export Generator field sets the Apex class, which controls the file format of the GL Export. Then, on each entity, you set the Batch Export Configuration that will be used for the entity's export files. Nimble AMS by default supports export for the following GL systems:

GL SystemSupported File FormatGL Exports benefit to existing customers

Microsoft Dynamics Great Plains 

.txt
  • Point & click customization will be added to functionality.

  • Ability to switch to other GL systems given the new GL system supports one of the 3 supported file formats.

Sage Intacct

.csv
  • Ability for point & click customization will be retained.
  • Ability to switch to other GL systems given the new GL system supports one of the 3 supported file formats.

QuickBooks Online

.csv
  • Ability for point & click customization will be retained.
  • Ability to switch to other GL systems given the new GL system supports one of the 3 supported file formats.

QuickBooks Desktop

.iif
  • Point & click customization will be added to functionality.

  • Ability to switch to other GL systems given the new GL system supports one of the 3 supported file formats.

Table 1.

How to get started

Nimble AMS customers can already export financial transactions to their GL system of choice through Batch Export Configurations. 

As of our Summer 22 release Nimble AMS standardized support for the following

  1. Standardized support for GL systems noted above in Table 1.
  2. Point and Click setup for other GL systems through .csv, .txt or .iif file formats.

Please contact support to learn more about how to take advantage of these improvements.