Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
April 7, 2023
Solved

Split a banking deposit and change date

  • April 7, 2023
  • 1 reply
  • 63 views

Hello,

 

I connect directly with my bank for our transactions, the problem I have is we use shopify for our sales. Shopify will group payments from days especially over weekends, which isn't usually a problem mid month but it does for end of month/quarter when it runs across months.

 

I use split on transactions all the time however I can't work out how to change the date on a split, all I would need is to change one for the month before (last day of month), then one on the 1st. I am not particular about each transaction, I just want the sales to fall within the correct month.

 

Any advice?

 

Thanks

Best answer by Nicole_N

Hi, thanks for taking the time to post your concern here.

 

Please know that dividing deposits with different dates is unavailable. As a workaround, we can record two deposits in QuickBooks with different dates. Then, match it to the deposit that shows up on the Banking page.

 

With the use of an Undeposited Funds account, you can deposit the amounts of the invoice payments that you've recorded.

 

To deposit the payments with different dates, we need to create the transaction separately.

 

Here's how:

  1. Go to + New on the left panel.
  2. Under Other, select Bank deposit.
  3. Select the Bank account from the drop-down menu. 
  4. Select the Date of the first payment you want to deposit.
  5. Put a check mark on the first payment you want to deposit.
  6. Click Save and Close.

 

Follow the same process with the second payment.

 

Once done, let's go to the Banking section and match the transactions by following these steps:

 

  1. Go to Banking on the left panel.
  2. In the For Review section, select the transaction.
  3. Choose the Find Match option.
  4. In the Match transactions window, select Deposits from the first drop-down, enter the amount (Optional), and select the From and To date.
  5. Put a checkmark on the deposits you recorded. 
  6. Click Save.

 

Furthermore, there's a specific report where you can view the complete list of your transactions with splits. It's the Transaction List with Splits. To pull it up, here's how: 

 

  1. Go to the Reports menu.
  2. Search for Transaction List with Splits.
  3. Select the Customize button.
  4. Set the date range in the Report period section.
  5. Change the columns by selecting the Rows/Columns drop-down arrow.
  6. Select the specific information you want in the Filter drop-down.
  7. Click Run report.

 

 If you want to edit the transaction, click on the transaction type.

 

Once done, you can memorize the Transaction List with Splits report to save its current customization settings. For the detailed steps, kindly refer to this article: Memorize reports in QuickBooks Online. It also contains information on how to set a schedule and email the memorized report.

 

Leave a reply if you have additional questions. The Community is here to help. 

1 reply

Nicole_N
Nicole_NQuickBooks TeamAnswer
QuickBooks Team
April 8, 2023

Hi, thanks for taking the time to post your concern here.

 

Please know that dividing deposits with different dates is unavailable. As a workaround, we can record two deposits in QuickBooks with different dates. Then, match it to the deposit that shows up on the Banking page.

 

With the use of an Undeposited Funds account, you can deposit the amounts of the invoice payments that you've recorded.

 

To deposit the payments with different dates, we need to create the transaction separately.

 

Here's how:

  1. Go to + New on the left panel.
  2. Under Other, select Bank deposit.
  3. Select the Bank account from the drop-down menu. 
  4. Select the Date of the first payment you want to deposit.
  5. Put a check mark on the first payment you want to deposit.
  6. Click Save and Close.

 

Follow the same process with the second payment.

 

Once done, let's go to the Banking section and match the transactions by following these steps:

 

  1. Go to Banking on the left panel.
  2. In the For Review section, select the transaction.
  3. Choose the Find Match option.
  4. In the Match transactions window, select Deposits from the first drop-down, enter the amount (Optional), and select the From and To date.
  5. Put a checkmark on the deposits you recorded. 
  6. Click Save.

 

Furthermore, there's a specific report where you can view the complete list of your transactions with splits. It's the Transaction List with Splits. To pull it up, here's how: 

 

  1. Go to the Reports menu.
  2. Search for Transaction List with Splits.
  3. Select the Customize button.
  4. Set the date range in the Report period section.
  5. Change the columns by selecting the Rows/Columns drop-down arrow.
  6. Select the specific information you want in the Filter drop-down.
  7. Click Run report.

 

 If you want to edit the transaction, click on the transaction type.

 

Once done, you can memorize the Transaction List with Splits report to save its current customization settings. For the detailed steps, kindly refer to this article: Memorize reports in QuickBooks Online. It also contains information on how to set a schedule and email the memorized report.

 

Leave a reply if you have additional questions. The Community is here to help. 

May 5, 2023

Hello,

 

This did help however it appears things have changed now? Before there was a check mark, and now it's not. I tried uploading the transactions separately but it's not finding the matching banking transaction.

 

Last month this worked fine,

 

Thanks,

 

Ben

July 9, 2023

Hello - Is there any update on this, the transactions don't go to review anymore, therefore I can't link the splits with the bank transaction.

 

Thanks,