cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
rajesh-kathiru
Level 1

Is there a way to split a transaction (downloaded from bank) into expenses with different dates

In Quick books, I am trying to expense my payroll transaction  (from third party payroll provider) into the correct month in which it was incurred. Whenever payroll is paid in the first or second week of a month, half the pay needs to be attributed to the previous month for correct profit/loss calculation. I am wondering if there is an easy way to do this in Quick books
3 Comments 3
JamaicaA
QuickBooks Team

Is there a way to split a transaction (downloaded from bank) into expenses with different dates

Congratulations on making your first post here, @rajesh. I'll provide some information about splitting transactions into different dates.

 

When you split a transaction, you can only select the Received from, Category, Description, and Amount. This means we’re unable to choose which date you’d like to assign the other transaction. Once you’ve set everything, you can now click Apply and accept. 

 

As a workaround, you can manually create transactions within the program. From there, use the Find match in the banking page. 

 

The Community is always eager to help if you have other questions navigating your account. Post a comment below, and I'll get back to you as soon as I can.

rajesh-kathiru
Level 1

Is there a way to split a transaction (downloaded from bank) into expenses with different dates

Thank you @JamaicaA I will try out your recommendation. Because this use case is very common, I am wondering if there is a way to create a bill or accounts payable and close it out when the transaction is downloaded. 

ReymondO
Moderator

Is there a way to split a transaction (downloaded from bank) into expenses with different dates

Thanks for getting back to this thread, @rajesh-kathiru.

 

Allow me to join in this conversation and share insights in tracking your transactions in QuickBooks. 

 

Yes, you can create a bill and leave it open if you're on its window. However, you won't be able to open any other window without closing the transaction.

 

On the other hand, you can create and close a bill before the transaction is downloaded. Once downloaded to your Banking page, use the Pay bills feature to record the payment.   

 

Here's how: 

 

  1. Select + New and click Pay bills.
  2. From the Payment account drop-down menu, choose the account you paid the bill from.
  3. Enter the Payment date.
  4. Select the checkboxes for the bill(s) you made a payment towards.
  5. In the Payment column, enter the amount you paid toward each bill.
  6. Click Save.

 

To know more about recording business expenses in QuickBooks, please check out this article: Enter and manage bills and bill payments in QuickBooks Online.

 

Leave a comment below if you have other concerns related to handling bills. The Community and I will be around to help you.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us