Skip to main content
January 26, 2022
Question

Matching transactions by project

  • January 26, 2022
  • 1 reply
  • 0 views

Hello.

I would like to find out if it is possible to include 'Project' and 'Payment Method' fields into the table that is generated for 'Matching Transactions'.

 

Our situation is that we withdraw cash from the company's main bank account to give to field operatives before they go out for work (anywhere between 1-2 months). The operatives may spend the cash or also use direct debit card from the main account. The field operatives can be working on different projects at the same time. We have just converted across from freshbooks and spent weeks entering all our expenses into the QB system and classifying each expense according to project. Now we are in the process of matching the expenses against the separate ATM withdrawls. As you can see it will be necessary now and into the future to make sure we align these withdrawls with the correct projects so that we can balance the account of the amount given to the field operatives. Please advise if there is a work around solution to this.... Could this also go as a recommendation for the QB software development team to make the settings icon next to the 'matching transaction' sheet functional and allow to toggle on and off the different fields associated with expenses (as is possible for many of the other tables and reports).

 

Many thanks in advance for any support.

1 reply

January 26, 2022

Your voice and ideas matter to us, AWillson. I'm here to help you send product suggestions.

 

I can see how the functionality to select a project, payment method, and the ability to toggle on and off the different fields associated with expenses in the Match Transactions window would be beneficial to your business. With this, I'd recommend sending a feature request directly to our Product Development team. This helps us improve your experience with the program. 

 

Here's how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.
    Capture.PNG

 

To ensure your transactions are categorised accurately in QuickBooks, I'd suggest following this article: Match Online Bank Data.

 

Once done categorising, you can start reconciling your account in QuickBooks. This way, they'll always match your bank and credit card statements.

 

I'm only a post away if you need more help in managing your bank transactions in QuickBooks, AWillson. It's always my pleasure to help you out again.