cancel
Showing results for 
Search instead for 
Did you mean: 
Kac5208
Level 2

Match a money transfer in your imported bank transactions

I need to match multiple bank transfers from one of our business accounts to the other account. 

 I found the article for QB online but that the steps dont match for QB Mac Desktop. 

5 Comments 5
TirzahC
QuickBooks Team

Match a money transfer in your imported bank transactions

Hi, Kac.

 

To ease the process of handling your bank entries, you may connect your banks for an online banking connection first. We can click on the Set up Direct Connect link from this article as your reference: Set up online banking for QuickBooks Desktop for Mac.

 

Before we can proceed to match the transactions, you'll want to ensure that the check number, amount date, and payee name must be the same as the transaction in QuickBooks. It should be observed to match every transaction.

 

In addition, it will also affect the matching process if the transactions are new or reconciled.

 

Now, here's how to match the transactions:

 

  1. Go to the Banking menu and select Downloaded Transactions.
  2. Select the QuickBooks Account window if you have more than one account.
  3. Click on the unmatched transactions in QuickBooks and register you wish to match. Unmatched transactions don't have an orange circle next to them.
  4. Select Match.

We can also add a new transaction by clicking on Add One or Add Multiple.

 

I've got an article to know more about managing online banking features: Add and match transactions in QBDT for Mac. It also contains future references such as fixing issues and disconnecting with QB Online banking for an account.

 

If we encounter any issues with online banking, we can keep this article for future reference: Fix online banking issues in QuickBooks Desktop for Mac

 

Let me know by adding a comment below If you have any other questions while working with QBDT for Mac. I'm always here to provide additional assistance. Keep safe!

Kac5208
Level 2

Match a money transfer in your imported bank transactions

I apologize, I should have been more detailed.

My old account is no longer setup for auto download as the account has been closed. So I need to manually match so i can reconcile.

 

My bank statement of my old account shows multiple transfers to new account. 

Maybelle_S
QuickBooks Team

Match a money transfer in your imported bank transactions

I can help match the imported transactions, @Kac5208.

 

When you download transactions through Web Connect, QuickBooks opens them from a .qbo file. If you haven't downloaded the transactions yet, you can follow the steps below:

 

Here's how:

 

  1. Go to the Banking menu.
  2. Select Website. It opens a browser window to your bank’s website.
  3. Sign in to your online banking account.
  4. Go to your transactions, then enter the time you wish to display.
  5. In QuickBooks, go to the Banking menu.
  6. Click Downloaded Transactions.
  7. Select Import File, then look for the .qbo file you downloaded.

 

Once done, you can now review and match the downloaded transactions.

 

I've added this link about reconciling transactions in QuickBooks: Reconcile an account.

 

Please keep us posted on how it goes. We're always around to help reconcile your account. Take care and stay safe.

Kac5208
Level 2

Match a money transfer in your imported bank transactions

Hi Maybelle,

That account is not available  anymore as it is a closed account.

How can i record a transfer manually? 

Rea_M
Moderator

Match a money transfer in your imported bank transactions

Thanks for the update, @Kac5208.

 

Let's activate your closed account temporarily so you can record a manual transfer of funds in QuickBooks Desktop (QBDT) for Mac and keep your financial data accurate.

 

When recording a transfer between two accounts, both of them should be active in your list. Though the other one is already closed, you'll have to enable or activate it temporarily to record a manual transfer. Before doing so, I encourage you to consult with your accountant. They can provide expert advice tailored to your business needs.

 

Whenever you're ready, follow these steps to make an account active:

 

  1. Go to the Lists menu, then select Chart of Accounts.
  2. From the View ▼dropdown, select All Accounts.
  3. Select the account you want to make active again.
  4. Click Settings , then select Make Account(s) Active.

 

You can read this article for more details about managing accounts from your chart of accounts in QBDT for Mac: Add, edit, or delete accounts in QuickBooks Desktop.

 

Once you're done, go ahead and do a manual transfer via check or journal entry. Then, match them to your downloaded bank transactions. Please see this article for the complete guide: Add and match transactions in QuickBooks Desktop for Mac.

 

When everything is all set, you can inactivate your closed account again. Then, reconcile the active one.

 

Also, I encourage you to reconcile your accounts in QBDT for Mac regularly (every month). This helps monitor your income and expense transactions and detect possible errors accordingly. You may want to check out this article as your reference to guide you in doing and fixing reconciliations in QBDT for Mac: Learn the reconcile workflow in QuickBooks.

 

Please feel free to leave a comment below if you have other banking concerns or questions about managing transactions in QBDT for Mac. I'm always ready to help. Take care, and stay safe, @Kac5208.

Need to get in touch?

Contact us