Importing from Quickbooks Desktop Pro

Here’s how to prepare your files for importing your historical data from Quickbooks Online to MoneyMinder:
*$19/year import fee.

You will need to export two QB reports to do an import for a financial year. They must be the same date range and have the same financial year indicated in the name of the report.

You will also need your MoneyMinder Customer ID (see note at end of this article for locating this).

 

1 – Log into your Quickbooks Desktop Pro account and go to Reports > Banking.


2 – Select the Deposit Detail Report:


3 – Choose the date range for the full year that you want to import (e.g. from 1/1/2020 – 12/31/2020 or from 7/1/2019 – 6/30/2020). Make sure these columns are showing: Type, Num, Date, Name, Account, Amount.

Note: Run a separate report for each financial year you’d like to import.


4 – Choose Excel and Create New Worksheet. You do not need to select any other options.


5 – Choose Export.


6 – When the file has downloaded, go to Excel, open the file and Save As using the following naming convention: MM Customer ID Deposit Details Report FY20xx (e.g. MM13211 Deposit Details Report FY2025).


7 – Click Save.


8 – Next we’ll get the Withdrawals reports. Go to Reports > Banking.


9 – Select the Check Detail Report:


10 – Choose the date range for the full year that you want to import (e.g. from 1/1/2020 – 12/31/2020 or from 7/1/2019 – 6/30/2020). Make sure these solumns are showing: Type, Num, Date, Name, Item, Account, Paid Amount, Original Amount.

Note: Run a separate report for each financial year you’d like to import.


11 – Choose Excel and Create New Worksheet. You do not need to select any other options.


12 – Choose Export.


13 – When the file has downloaded, go to Excel, open the file and Save As using the following naming convention: MM Customer ID Deposit Details Report FY20xx (e.g. MM13211 Deposit Details Report FY2025).


14 – Click Save.


15 – Email your files to [email protected]

Subject: QB Desktop Import files for your organization’s name and Customer ID.

Attach the 2 files (per year).

Include your name and contact phone number in case we have questions.


NOTE:

You can find your MoneyMinder Customer ID by clicking on the Account link in MoneyMinder:

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.