Export Journal Entries to Your Accounting System
After completing this unit, you’ll be able to:
- Export your journal entries to your accounting system.
- Customize your reports for export.
Moving From System to System
Our (fictional) nonprofit, No More Homelessness (NMH), has been using Accounting Subledger for one entire accounting period, and it’s time for the first big export.
Sam, the Finance Director, is excited. She’s followed along with how the data has been created in Salesforce and—with some help and training from her consulting partner—it’s time to take that information off to its final home in the accounting system of record.
Because Sam uses a fairly common accounting system, there’s an Accounting Subledger template report already set up for her in Salesforce. (Check the links in the Resources section at the end of this unit for a list of available templates to see if your organization’s accounting system is supported.)
Let’s get down to exporting.
Understanding Export Templates
If your accounting system has a template already set up in Accounting Subledger, you can start by entering the name of that template in the Global Search bar and clicking to open it. To show you the general idea, we’ll start here by searching for and using the Accounting Subledger Common Template, which supports commonly used ledger entry fields but isn’t designed for a particular accounting system.
By default, the report includes these fields that you can map to your accounting system:
- Transaction Date
- Opportunity Name
- GL Code
- Debit Amount
- Credit Amount
- Accounting Period
- Fulfills a Pledge?
To export the report:
- Select Export from the dropdown menu.
- Select Details Only, then set the Format to Comma Delimited .csv. (Note: Details Only is the recommended export view for uploading to other systems.)
- Click Export.
And there you go, a handy .csv file that can be imported to your accounting system. You may want to open it in your favorite spreadsheet editor for review and updating first.
If you find yourself making a lot of changes or reordering rows, you can always change the report you export from Salesforce.
Customize a Report for Export
Salesforce is a flexible platform that can be customized to meet your needs, and these reports are no different. If your accounting software isn’t supported with an out-of-the-box template or if you’d just like to change the order of columns or add additional information, you can create custom reports or save a copy of an existing report and modify it to your needs.
Let’s do just that with the Accounting Subledger Common Template.
Accounting Subledger Common Templatein Global Search and click on the report to open it.
- In the upper right corner, click the down arrow and then Save As to save a copy with a new report name.
- Once you’ve saved a new copy, you can click Edit in the upper right corner.
- In the Columns area, click into the Add column… search bar then find and select Check/Reference Number, Ledger Entry: ID, and Ledger Entry: Owner Name.
- Click Refresh to view the changes in report view, then click Save & Run to view the full report.
If this meets your needs, you can export it just like the standard template. (And if you’d like to learn more about customizing reports in Salesforce, be sure to complete the Reports & Dashboards for Lightning Experience module linked in Resources below.)
Better Results Through Faster Accounting
At NMH, Sam completed her export, imported it into her accounting system, and was able to reconcile and close the books in record time. She had new insight into the fundraising team’s results, and she didn’t have to ask them questions while they were juggling donor meetings and campaign planning.
Accounting Subledger freed up time for everyone to do their best work. That makes Sam and Aniyah, the Development Director, happy. And that’s not to mention how pleased their Executive Director and board are to have financial results sooner, allowing them to better forecast, plan, and respond to changes in program demand and world events.
More time and more trust: That’s what automatically translating fundraising data into accounting data through Accounting Subledger is able to provide.