Export Novat Transactions Into QuickBooks Desktop

Novat
|
37 steps
|
43 seconds

Novat

Open QuickBooks Desktop

Step 1: Bulk Add Vendors

Click "Vendors"

Click "Vendor Center"

Click "New Vendor"

Click "Add Multiple Vendors"

Click on the next blank space

Option 1: Import Vendor/Payees from Novat.ai

Click "Export"

Click "Copy Vendors/Payees"

Option 2: Copy Vendor/Payees from Excel

Click on "Unique Rules" in Downloaded Excel

Select the items in the first column and copy you data by pressing [[cmd]] + [[c]] (mac) or [[ctrl]] + [[c]] (windows)

Paste you data by pressing [[cmd]] + [[v]] (mac) or [[ctrl]] + [[v]] (windows)

Click "Save Changes"

Tip! QuickBooks Desktop automatically detects duplicates!

Quickbooks Desktop automatically detects duplicates. Click on "OK"

You can safely ignore this error

Safely click on "Close" to discard leftover duplicates

Safely click on "No" to discard unsaved duplicate changes

Step 2: Batch Enter Transactions

Click on "Accountant"

Click on "Batch Enter Transactions"

Add "Checks" for Checking Bank Account

Select "Checks" in "Transaction Type"

Tip! Make sure you are adding the transactions the the right "Bank Account", and the right "Transaction Type"

Select your Bank Account

Click on the top left cell

Option 1: Copy Transactions Directly from novat.ai

Click "Copy Additions (+)" or "Copy Withdrawals (-)"

Option 2: Paste Transaction Data from Excel

Make sure the Excel columns order and the QuickBooks column order match Select the transactions in your Excel by pressing [[cmd]] + [[c]] (mac) or [[ctrl]] + [[c]] (windows)

Tip! Make sure the columns order and the QuickBooks column order match \ i.e. Date, Number, Payee, Account, Amount, Memo

Paste you data by pressing [[cmd]] + [[v]] (mac) or [[ctrl]] + [[v]] (windows)

Click on "Save Transactions"

Click on "Yes" after confirming which account this will be saved to

Add "Deposits" for Checking Bank Account

Change "Transaction Type" to "Deposits"

Click on the top left cell

Tip! Make sure the Excel columns order and the QuickBooks column order match

Select the transactions in your Excel by pressing [[cmd]] + [[c]] (mac) or [[ctrl]] + [[c]] (windows)

Paste you data by pressing [[cmd]] + [[v]] (mac) or [[ctrl]] + [[v]] (windows) \ \ Click on "Save Transactions"

Click on "Yes" after confirming which account this will be saved to

Add Transactions for Credit Card Account

Select "Credit Card Changes & Credit" in "Transaction Type"

Tip! Make sure the Excel columns order and the QuickBooks column order match

Tip! Include the "Ref" column for easier reconciliations!

Select the transactions in your Excel by pressing [[cmd]] + [[c]] (mac) or [[ctrl]] + [[c]] (windows)

Click on the top left cell

Paste you data by pressing [[cmd]] + [[v]] (mac) or [[ctrl]] + [[v]] (windows)\ \ Click on "Save Transactions"

Click on "Yes" after confirming which account this will be saved to