--- title: "EOM Accounting Export With Transaction Pro" slug: "eom-accounting-export-with-transaction-pro" tags: ["Language - English", "Area - End of Month", "Industry - Landscaping", "Type - Task (How-To)", "Role - Accountant (AR)", "Skill Level - 2 (Intermediate)", "Skill Level - 3 (Advanced)"] updated: 2025-10-09T15:13:23Z published: 2025-10-09T15:13:23Z canonical: "guide.youraspire.com/eom-accounting-export-with-transaction-pro" --- > ## Documentation Index > Fetch the complete documentation index at: https://guide.youraspire.com/llms.txt > Use this file to discover all available pages before exploring further. # EOM Accounting Export With Transaction Pro ## **Purpose** The EOM *Revenue* and *Expense* journal entries can be exported to *Excel* and that file can be imported into *QuickBooks* using a program called *Transaction Pro*. The program is available for both *QuickBooks Desktop* and *QuickBooks Online*. Importing the journal entry can save you time each month because you will no longer need to manually enter the revenue and expense journal entries into *QuickBooks*. In order to use the *Export File Feature with QuickBooks Online or QuickBooks Desktop,* you will need to purchase and download *Transactions Pro Importer.* You may also need to add some additional accounts to your chart of accounts in your accounting system. πŸ“ŒNote: To purchase and download *Transaction Pro* contact *QuickBooks*. ## **GL Account Numbers** For the import to work properly you will need to use *Account Numbers* in *QuickBooks* and possibly add some account numbers to your *Chart of Accounts.* If you are not currently using *Account Numbers* in your *Chart of Accounts,* you must be in single-user mode and then can turn the functionality on in *Preferences*. ### **QuickBooks Desktop** To enable account numbers in *QuickBooks Desktop*: 1. Click on the *Edit* option in the menu bar and select Preferences from the drop-down menu. 2. Select *Accounting* from the options on the left. 3. Select the *Company Preferences* tab. 4. Under the *Accounts* section at the top of the window, click to put a checkmark in the option, *Use* *Account Numbers*. 5. Select the OK button. ![](https://cdn.document360.io/5942a8d7-f3b1-4919-bdfa-d477d8498fe3/Images/Documentation/eom-accounting-export-with-transaction-pro-image-s5006d3v.png?sv=2026-02-06&spr=https&st=2026-11-15T01%3A17%3A41Z&se=2026-11-15T02%3A17%3A41Z&sr=c&sp=r&sig=4F23m%2FX57lmOoU%2FQwRFoEdfugnQoxfJfPBqz3agKswU%3D) ### **QuickBooks Online** To enable account numbers in *QuickBooks Online*: 1. Go to the *Settings* icon and select *Account and Settings.* 2. Select *Advanced*. 3. Select *Edit* icon in the *Chart of Accounts* section. 4. Select *Enable Account Numbers*. If you want the account numbers to show on reports and transactions, select *Show Account Numbers*. 5. Select *Save*. 6. Exit the window. ![](https://cdn.document360.io/5942a8d7-f3b1-4919-bdfa-d477d8498fe3/Images/Documentation/eom-accounting-export-with-transaction-pro-image-zfqa98nv.png?sv=2026-02-06&spr=https&st=2026-11-15T01%3A17%3A41Z&se=2026-11-15T02%3A17%3A41Z&sr=c&sp=r&sig=4F23m%2FX57lmOoU%2FQwRFoEdfugnQoxfJfPBqz3agKswU%3D) ## **Account Numbers to Add to the Chart of Accounts** The following accounts (*Account Name - Account Type*) will need to be added to your accounting system if they are not already set up. Assign account numbers that are consistent with your current account numbering format. - Checking Account - Bank - Accounts Receivable – Accounts Receivable - Accounts Payable – Accounts Payable - Inventory Holding – Other Current Asset - Inventory Holding Material – Other Current Asset - Sub account of Inventory Holding - Inventory Holding Equipment – Other Current Asset - Sub account of Inventory Holding - Inventory Holding Subcontractor – Other Current Asset - Sub account of Inventory Holding - Inventory Holding Other – Other Current Asset - Sub account of Inventory Holding - Over/Under (Earned Revenue > Invoiced Revenue) – Other Current Asset - Only required if you are reporting Earned Revenue - Sales Tax Payable – Other Current Liability - Needed only if you bill tax to your customers - Over/Under (Invoiced Revenue > Earned Revenue) – Other Current Liability - Only required if you are reporting Earned Revenue - Revenue – Income - Revenue Account for each division if the COA is setup to that detail - Revenue Variance – Income - Only required if you are reporting Earned Revenue - Invoice Adjustments – Income - Miscellaneous Invoice Revenue - Income - Cost of Goods Sold Material – Cost of Goods Sold - Cost of Goods Sold Equipment – Cost of Goods Sold - Cost of Goods Sold Subcontractor – Cost of Goods Sold - Cost of Goods Sold Other – Cost of Goods Sold - COGS Account for each division if the COA is setup to that detail ## **Aspire Setups** After you have downloaded *Transaction Pro* and added the required *GL Account Numbers* in your *Accounting System*, you will need to complete the setups in Aspire located in *Application* ▢️*Configuration* and in the *Divisions* and *Payment Categories* of the *Lists* tab. ### **Application Configuration** In the *Application Configuration* you will need to enable the *End of Month Accounting Export* feature and map accounts to the *Accounting System Chart of Accounts.* To open the *Application Configuration* screen: 1. Click on the profile icon in the lower left corner of Aspire and select *Administration* from the menu. 2. From the *Administration* screen, click on *Configuration* in the upper right-hand corner to open the *Application Configuration* screen. 3. Select the *Accounting Sync* tab. 4. Click to put a checkmark in the field labeled, *Enable EOM Export*. When this box is selected additional fields will be displayed at the bottom of the screen. Complete the fields that are appropriate for your company. The additional fields that are displayed include: - Export Revenue Type (required): Select either *Invoiced* or *Earned* depending on how you report revenue on your *Profit & Loss* statement. If you select *Invoiced,* the debit amounts under A/R on your *End of Month* report on the *Revenue* tab will be used as the credit amounts to your revenue accounts. If you choose *Earned*, the credit amounts under *Earned Revenue* will post as credits to your revenue accounts. - Sales Tax Payable (optional): If you charge sales tax to your customers, enter the *GL Sales Tax Payable*, liability account number from your *Chart of Accounts.* The amount from the End of Month report, Revenue tab, under the Revenue section for Sales Tax will be posted as a credit to this account. - AR Account (required): Enter your *Accounts Receivable* account number. The total of the amounts from the *End of Month* report, *Revenue* tab, in the A/R section will post as a debit to this account. - Sales Tax Vendor Account (optional): If you charge sales tax to your customers you will need to complete this field. Enter the *Vendo*r name, exactly as it appears in *QuickBooks* in the *Vendor Center*. - Equipment Account (required): Enter your *Inventory Holding – Equipment Rental* account number. The amount from the *End of Month* report, Expense tab, for *Inventory Holding Equipment* will post as a credit to this account. - Other Account (required): Enter your Inventory Holding – Other account number. The amount from the *End of Month* report, *Expense* tab, for *Inventory Holding Other* will post as a credit to this account. - Invoice Adjustments Account (required): Enter the *Invoice Adjustments* account number. The amount from the *End of Month* report, *Revenue* tab, under the *Revenue* section for *Invoice Adjustments* will be posted as a credit to this account. - Over/Under Account: This field will be required if you selected *Earned* for the *Export Revenue Type*. Enter either the *Invoiced Revenue > Earned Revenue* account number or the *Earned Revenue > Invoiced Revenue* account number. The amount from the *End of Month* report, *Revenue* tab, under the *Revenue* section for Over/Under will post as a debit or credit to this account. - Misc. Invoice Account (required): Enter the *Miscellaneous Invoice* account number. The amount from the *End of Month* report, *Revenue* tab, under the *Revenue* section for *Misc. Invoices* will be posted as a credit to this account. - Material Account (required): Enter your *Inventory Holding – Material* account number. The amount from the *End of Month* report, *Expense* tab, for *Inventory Holding Material* will post as a credit to this account. - Sub Account (required): Enter your *Inventory Holding – Subcontractor* account number. The amount from the *End of Month* report, *Expense* tab, for *Inventory Holding Sub* will be posted as a credit to this account. ### **Division Account Numbers** When the *Enable EOM Export* checkbox is checked, Aspire will add additional fields to the *Division* screen in the *Lists* in the *Application* in *Administration*. These fields allow you to specify account numbers in your accounting system that tie to each division. To open the Manage Lists screen: Hover over your profile icon in the lower left corner of *Aspire* and select *Administration* from the menu. 1. From the *Administration* screen, click on *Lists* in *Application*. 2. In the *List Name* drop-down field, select *Division*. 3. Click on a *Division* name to select it. 4. The additional fields that will be added to this screen include: 5. Revenue Account Number (required): Enter the Revenue account number for this division. The amount from the *End of Month* report, *Revenue* tab will be posted to this account for this division. - If you are reporting *Invoiced Revenue*, the amount in the *A/R* section will post as a credit to this account number. - If you are reporting Earned Revenue, the amount under the *Revenue* section will post as a credit to this account number. 1. Material Expense Account Number (required): Enter the *Cost of Goods Sold Material* account number for this division. The amount from the *End of Month* report, *Expense* tab, for the *Material* expense will be posted as a debit to this account. 2. Equipment Expense Account Number (required): Enter the *Cost of Goods Sold Equipment Rental* account number for this division. The amount from the *End of Month* report, *Expense* tab, for the *Equipment* expense will be posted as a debit to this account. 3. Sub Expense Account Number (required): Enter the *Cost of Goods Sold Subcontractor* account number for this division. The amount from the *End of Month* report, *Expense* tab, for the *Sub* expense will post as a debit to this account. 4. Other Expense Account Number (required): Enter the *Cost of Goods Sold Other* account number for this division. The amount from the *End of Month* report, *Expense* tab, for the *Other* expense will post as a debit to this account. ### **Payment Category Account Number** When the *Enable EOM Export checkbox* is checked, Aspire adds an *Account Number* field to the *Payment Category* screen available under the *Lists* option on the *Administration* screen in *Applications*. A *Payment Category* is a list of choices that can be added to *Credit Memos* in Aspire if the *Credit as Expense* box is checked. 1. Hover over your profile icon in the lower left corner of Aspire and select *Administration* from the menu. 2. From the *Administration* screen, click on *Lists* in the *Application* section. 3. In the *List* drop-down field, select *Payment Category.* 4. Click on a *Payment Category*. This field allows the user to specify account numbers in the accounting system that tie to each payment category (i.e. Maintenance Credit, Discount, Bad Debt, etc.). In the *Account Number* field enter in the account number you want associated with this payment category. ## **Exporting the End of Month Revenue and Expenses** Once end of month accounting export has been set up as described above, the *End of Month Report* provides options for performing the export: - Export Revenue to Excel - Export Expense to Excel By default, the file will be created for the last month’s amounts. If you need amounts for an earlier period, select the date range before creating the export file. The export for *Revenue* and *Expense* can be done from any of the tabs in the *End of Month* report. After selecting the export needed, a message will appear letting you know the download has completed. The exported .csv file can then be opened or saved and used to import the data into your QuickBooks. ## **Importing the .csv File into QuickBooks** ### **QuickBooks Online** To open the *Transaction Pro Importer* in *QuickBooks Online* and import the file: 1. Click on Apps in the navigation bar on the left-hand side of the screen. 2. Click on the My Apps option at the top of the screen. 3. Find the *Transaction Pro* app and select *Launch* in the Action drop down box. 4. Select the *Import* option to open the *Choose Import Type* window. 5. Select *Journal Entries* from the options listed. 6. Drag and drop the *Revenue or Expense* .csv file into the box OR click to open *File Explorer* to browse to the location of the saved Revenue or Expense .csv file from Aspire and click *Open*. 7. Click the *Select File and Sheet* button in the lower, right-hand corner 8. At the *Select File and Sheet* screen, click *Import Sheet* to open the *Match Columns to QuickBooks Fields* screen. 9. Match the *QuickBooks Fields* with *Import Column* headers from the Aspire export file. ![](https://cdn.document360.io/5942a8d7-f3b1-4919-bdfa-d477d8498fe3/Images/Documentation/eom-accounting-export-with-transaction-pro-image-9kmgu6wl.png?sv=2026-02-06&spr=https&st=2026-11-15T01%3A17%3A41Z&se=2026-11-15T02%3A17%3A41Z&sr=c&sp=r&sig=4F23m%2FX57lmOoU%2FQwRFoEdfugnQoxfJfPBqz3agKswU%3D) 1. Click the *Preview* *and Import* button in the lower, right-hand corner to open the *Preview* screen. 2. Review the import file and make any necessary corrections. 3. Click on the *Options* button in the upper, right-hand corner to open the *Import Options* screen and select the option to *Enable Account Numbers on Transactions*. 4. Click the *Import* button in the lower, right-hand corner. 5. A confirmation box will open; click *Yes.* 1. If there are any errors in the file a warning message will appear at the top of the screen in red font and the cell(s) causing the error will be highlighted in red. 2. If the import is successful you will receive a message highlighted in green at the top of the page reading, *Your data was imported successfully* . 6. Close the window. 7. Repeat the steps above as necessary to import the other Revenue or Expense Journal Entry. 8. Review the journal entry that is exported in the accounting system for accuracy. ### **QuickBooks Desktop** 1. Open the Transaction Pro Import Wizard program 2. Click the Browse button to open *File Explorer* and find the *Revenue or Expense* .csv file that was exported from Aspire and click *Open.* 3. If the box to select the *Field Delimiter* shows, choose *Comma.* 4. Select the QuickBooks transaction *Import Type* of Journal Entry. 5. Select *Next* to open the *File Contents* screen. ![](https://cdn.document360.io/5942a8d7-f3b1-4919-bdfa-d477d8498fe3/Images/Documentation/eom-accounting-export-with-transaction-pro-image-gm82krr5.png?sv=2026-02-06&spr=https&st=2026-11-15T01%3A17%3A41Z&se=2026-11-15T02%3A17%3A41Z&sr=c&sp=r&sig=4F23m%2FX57lmOoU%2FQwRFoEdfugnQoxfJfPBqz3agKswU%3D) 1. Review the Aspire file and click *Next* to open the field mapping screen. 2. Map the *Import File Column* field in the Aspire .csv file to the *QuickBooks Fields* in the drop-down list. 3. Review the data and make any necessary edits and then click the *Next* button to open the *QuickBooks Item Settings* screen. 4. Click *Finish* to start the import of the file. The progress bar will display the status of the import. 5. Repeat steps A - I to import the other (Revenue or Expense) *Journal Entry.* 6. Review the journal entry that exported in the accounting system for accuracy.