Questions? We have answers.

QuickBooks Desktop/Enterprise Solutions: Import the general ledger into MindBridge

  • Updated

Summary

This guide will cover the process of importing a QuickBooks Desktop/Enterprise Solutions general ledger into MindBridge.


Notes/Prerequisites

The general ledger column mapping section of this guide is based on data that has been exported using our QuickBooks Desktop/Enterprise Solutions Journal Export guide and formatted using our QuickBooks Desktop/Enterprise Solutions Journal Transformation guide. Note that the QuickBooks Journal cannot be ingested into Mindbridge without first formatting it. 


Import data

  1. Import your general ledger file into MindBridge through the File Manager, or by importing directly to the General Ledger section on the Data page. For step-by-step instructions, follow our Import a general ledger guide until the Map Columns step.
  2. Map the QuickBooks fields as follows:

MindBridge Column

QuickBooks Field

Notes

Account ID

Account ID

Required

Yes

 

Effective Date

Date

Required

Yes

Appears in format M/D/YYYY

Debit

Debit

Required

Yes

 

Credit

Credit

Required

Yes

 

Transaction ID

Trans#

Recommended

Yes

Note that there may not be values present for every transaction. This will be covered in more detail below under the Transaction ID Generation section

Memo

Memo

Recommended

Yes

This will enable the Empty Text control point and allow you to see the memo field for each transaction/entry

Account Description

Account Description

Optional

No

Can be left out as this field will be picked up from the Chart of Accounts

Type

Type

Optional

Yes

 

User ID

User

Optional

No

Use to sort and filter results for reports

Entered Date

Entered

Optional

Yes

 

Source

Source

Optional

Yes

 

* Optional columns, even if not used in the analytics, can be included for filtering and other visualizations, as indicated under Notes.

 

Transaction ID Generation

Since the transaction number field is not mandatory in QuickBooks, it is quite common to find that transactions in the Journal do not have a transaction number. We can use the fact that the journal groups transactions to our advantage however, by using the Custom Running Total feature within Mindbridge. This will allow us to generate a new transaction ID. 

Continue the import of the general ledger until you reach the Review Data: General Ledger step. In the Select Transaction Identifier drop down menu, select Custom Running Total and in the second drop down select Date:

mceclip0.png

Click Generate Preview to see a preview of the transaction length summary.

 


Previous step: QuickBooks Desktop/Enterprise Solutions: Transform the general ledger


What do you think of this guide? If you have any feedback, or you think you can help us improve it, then we would love to hear from you! Please contact us at support@mindbridge.ai. We are offering rewards for any information that leads to the improvement of a guide or the creation of a new one.


Anything else on your mind? Chat with us or submit a request for further assistance.

Was this article helpful?