cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Jadallah
Level 2

Link between Bill and Cheque Expenses ?

Dear QBO 

i have the system QBO and i start to enter the historical data 
i upload all the purchasing as Bill and its show now in suppliers account 
and after that i upload my bank account and from Bank module the payment for same suppliers i make it Cheque Exp 

Now how i can make link between them in statement of account 
in attached photo you can find the bills and payment in red its match but the statement balance not correct 

 
thanks all 

Solved
Best answer November 10, 2020

Best Answers
ChristieAnn
QuickBooks Team

Link between Bill and Cheque Expenses ?

Hi there, Jadallah.

 

I'm glad to see you here in QuickBooks Community. I'll provide information about downloaded transactions and how it works in QuickBooks.

 

When you downloaded the bank transactions., it goes directly to the For Review tab on the Banking page. QuickBooks automatically finds a match if you have entries from downloaded transactions that have the same amounts. With this, you'll need to link by matching the Bill and Payment so there aren't any duplicates. All you have to do is make sure the match is correct so that your account stays accurate and balance.

 

Here's how:

 

  1. Click Banking at the left panel.
  2. Choose the Banking section.
  3. Choose the downloaded transactions in the For Review section. Then, hit Match or Find Match.

 

 

For additional information, you can click this article: Categorise and match online bank transactions in QuickBooks Online.

 

However, if the Bill and payment have been added, I'd recommend undoing those transactions. This way, those entries will be moved back to the For Review section. That said, adding them could be the reason that the statement balance is not correct. Please follow the steps below on how to undo.

 

  1. Go to the Banking tab at the left panel.
  2. Click the Banking section and then select the bank.
  3. From the Reviewed or Categorised tab, look for the added transactions which are the Bill and Payment.
  4. Select the Undo from the ACTION column.

 

 

 

After that, you can now match the transactions and follow the steps provided above on how to perform this.

 

Please refer to this article to see steps on how you can reconcile your accounts so they match your bank and credit card statements to avoid discrepancies: Reconcile an account in QuickBooks Online.

 

Please let me know if you have any other concerns by leaving a comment in this thread. I'm more than willing to help. Have a good one!

View solution in original post

1 Comment 1
ChristieAnn
QuickBooks Team

Link between Bill and Cheque Expenses ?

Hi there, Jadallah.

 

I'm glad to see you here in QuickBooks Community. I'll provide information about downloaded transactions and how it works in QuickBooks.

 

When you downloaded the bank transactions., it goes directly to the For Review tab on the Banking page. QuickBooks automatically finds a match if you have entries from downloaded transactions that have the same amounts. With this, you'll need to link by matching the Bill and Payment so there aren't any duplicates. All you have to do is make sure the match is correct so that your account stays accurate and balance.

 

Here's how:

 

  1. Click Banking at the left panel.
  2. Choose the Banking section.
  3. Choose the downloaded transactions in the For Review section. Then, hit Match or Find Match.

 

 

For additional information, you can click this article: Categorise and match online bank transactions in QuickBooks Online.

 

However, if the Bill and payment have been added, I'd recommend undoing those transactions. This way, those entries will be moved back to the For Review section. That said, adding them could be the reason that the statement balance is not correct. Please follow the steps below on how to undo.

 

  1. Go to the Banking tab at the left panel.
  2. Click the Banking section and then select the bank.
  3. From the Reviewed or Categorised tab, look for the added transactions which are the Bill and Payment.
  4. Select the Undo from the ACTION column.

 

 

 

After that, you can now match the transactions and follow the steps provided above on how to perform this.

 

Please refer to this article to see steps on how you can reconcile your accounts so they match your bank and credit card statements to avoid discrepancies: Reconcile an account in QuickBooks Online.

 

Please let me know if you have any other concerns by leaving a comment in this thread. I'm more than willing to help. Have a good one!