Are you tired of dirty data living amongst your QuickBooks records?! Then it's time to clean and polish that data to a shine with the help of DataMaid, a QuickBooks Online data cleaning tool that sweeps and scans your data to identify errors and update them on the spot!
- On the DataMaid homepage, select 'Connect to QuickBooks'
- Sign-in to your QuickBooks account (if prompted)
- Select the account you would like to connect
- Select 'Authorize' to share your data between QuickBooks and Datamaid
DataMaid will now start analyzing your data!
Cleaning your data
Now that DataMaid is connected, the app has swept your data into the following dirty data piles:
Now, let's get these records polished!
The app will scan record names, emails, phone numbers, addresses, and ambiguous records for potential issues with the data and provide you with suggested fixes for that data.
For the Names section, feel free to select ignore if the name is correct. All other sections under Records must be fixed. Keep doing this until all your records have been cleared.
A very important section within Records is Ambiguous Records. A customer record is ambiguous if it has both:
- A First and Last Name
- A Company Name
...BUT the Display Name of the record does not exactly match either one (no middle name or initial in Display Name if it's a person record), the initial sync to bring those customers in from QuickBooks Online will fail due to Novi being unable to determine if the record is for a company or a person.
Remember that in Novi you will be creating separate records for people who serve as billing contacts, assuming they do not already have their own record within QuickBooks Online, so you do not need their name on the company record.
Note: If a record ONLY has a Display Name, it will default as a company record when imported to Novi.
After you've cleaned all your records, it's time to move to transactions. Click the 'Transactions' header to reveal potential errors in your data dues to Unapplied Payments, Missing Invoice Numbers and/or Payments Directly Deposited to the Bank.
This area may require a little more legwork and research into your QuickBooks transactions to figure out if the data needs to be fixed or ignored.
QuickBooks does not allow exact duplicates to be created, but duplicates can sneak into the system with slight name variations. For example, "The White House" and "White House, The" are probably the same record and would need to be merged. DataMaid will scan and identify any records that have an 80% name match.
The app will scan your customers, vendors, accounts and items to identify such potential duplicates. You can clear this out the same way you cleared your Records and Transactions lists.
If you don't have time to do all of this in one clean sweep, don't worry! You can always come back any time and reconnect your data. Happy Cleaning!