Split a banking deposit and change date

Baucebrothers · ‎April 07, 2023

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

Nicole_N · ‎April 07, 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:

Go to + New on the left panel.
Under Other, select Bank deposit.
Select the Bank account from the drop-down menu.
Select the Date of the first payment you want to deposit.
Put a check mark on the first payment you want to deposit.
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:

Go to Banking on the left panel.
In the For Review section, select the transaction.
Choose the Find Match option.
In the Match transactions window, select Deposits from the first drop-down, enter the amount (Optional), and select the From and To date.
Put a checkmark on the deposits you recorded.
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:

Go to the Reports menu.
Search for Transaction List with Splits.
Select the Customize button.
Set the date range in the Report period section.
Change the columns by selecting the Rows/Columns drop-down arrow.
Select the specific information you want in the Filter drop-down.
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.

View solution in original post

Nicole_N · ‎April 07, 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:

Go to + New on the left panel.
Under Other, select Bank deposit.
Select the Bank account from the drop-down menu.
Select the Date of the first payment you want to deposit.
Put a check mark on the first payment you want to deposit.
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:

Go to Banking on the left panel.
In the For Review section, select the transaction.
Choose the Find Match option.
In the Match transactions window, select Deposits from the first drop-down, enter the amount (Optional), and select the From and To date.
Put a checkmark on the deposits you recorded.
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:

Go to the Reports menu.
Search for Transaction List with Splits.
Select the Customize button.
Set the date range in the Report period section.
Change the columns by selecting the Rows/Columns drop-down arrow.
Select the specific information you want in the Filter drop-down.
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.

Baucebrothers · ‎May 05, 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

Baucebrothers · ‎July 09, 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,

AileneA · ‎July 09, 2023

Hello, Baucebrothers.

I've looked into it using my tools and couldn't find any ongoing issues with bank transactions not appearing in the review section. It seems like it is something to do with your browser cache. There are only a few occasions where the cache data accumulated by your browser can result in strange behavior like the one you experienced when using the software.

Pressing the F5 key on your keyboard will force a page refresh as a first step in solving this problem. If you're still getting the same result, I recommend accessing your account in a private/incognito window. This mode helps since it doesn't save any site data.

Here are the shortcut keys to use:

Google Chrome: press Ctrl + Shift + N.
Mozilla Firefox: press Ctrl + Shift + P.
Safari: press Command + Shift + N.

Go back to the Review window after signing in to check if those open bills are visible. If it rectifies the issue, switch to your main browser and clear its cache to remove outdated data. You might also try using a different supported browser to access your account.

Once everything works, you can start categorizing your transaction to ensure your data are accurate.

Furthermore, here's an article to help you reconcile: Reconcile an account in QuickBooks Online. This contains other sub-topics about fixing balance issues and what report you can pull up to review the reconciled transactions.

You can tag my name anytime if you need further assistance or if you have other questions. I'd love to answer them for you. Have a wonderful day ahead.

Topics

Training

Community

Resources

Split a banking deposit and change date