Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 5, 2023
Question

Sweep Account Set Up

  • October 5, 2023
  • 2 replies
  • 1 view

Our company started doing a nightly bank sweep into a money market account. A portion of the bank balance is swept out after hours and returned in the morning. I received our first statement and I'm having trouble with how I should record this in Quickbooks. Specifically, in September, the statement ends with 3 of the withdrawals being swept out but they were not returned until October. What is the most accurate way for me to set this up and record in Quickbooks? 

2 replies

AlcaeusF
Level 14
October 5, 2023

Hi there, kattu2km.

 

I'm here to help you set up a sweep account and record its transactions in QuickBooks Desktop (QBDT).

 

If it's a money market, you can easily create a bank account in QBDT to represent it. This way, you will have both your business checking account and your money market account properly set up. To accurately reflect the transfers between these two accounts, you can simply record them in QuickBooks. If both accounts are connected to online banking, the Bank Feed feature will automatically capture these transfers for you.

 

Regarding the sweep account, if it functions as a regular cash account, you only need to enter the transactions and reconcile the cash balance at the end of each month based on the statement provided.

 

To do this properly, I suggest consulting your accountant or accounting professional for further guidance with the process. Visit this link if you don't have an accountant yet: QuickBooks Certified ProAdvisor.

 

Moreover, I recommend performing a reconciliation on a regular basis to ensure your account is balanced and accurate. Refer to this article for future reference: Reconcile an account in QuickBooks Desktop.

 

Please post again if you have follow-up questions about this or anything else. I'm always here to assist. Stay safe.

October 19, 2023

I am not sure why I cannot reconcile my account and then tie into a sweep account.  Can you please me with this I am a desk top user not on line.

QuickBooks Team
October 19, 2023

Good day, @Sky Hi.

 

I would like to get to the bottom of this and lay down some solutions to help you reconcile accounts and tie them into a sweep account.

 

Before anything else, I want to ask a few questions to provide some troubleshooting steps. First, what challenges are you experiencing to reconcile? Is there any error that prevents you from doing so? Can you provide a screenshot?

 

More details would definitely help us narrow down the issue. Looking forward to your reply.

November 16, 2023

Good morning!  We started doing the nightly bank sweep in September as well.  Were you able to figure out how to set up and reconcile both the checking account and the new sweep account in QuickBooks?