Create a bill for my credit card statement, pay multiple times, then matching in bank feed

PinkyK · ‎February 24, 2023

Hello, I use QBO in the account view. I create a Bill when I receive my cc statement so it shows up in AP and I can see how much I still owe in Pay Bills. Then I make a payment every week to this bill and record each payment under Pay Bills. I always pay the cc off each month. But, when it comes to the bank feeds, I can not figure out how to handle those. I have tried doing it different ways but it always seems to duplicate or leave one out. What is the proper way to handle these bank feeds?

Rasa-LilaM · ‎February 24, 2023

Let me point you in the right direction direction on how to resolve your concern, PinkyK.

We'll have to exclude the duplicate entries. Then match the downloaded transactions to your bills to keep your records in order.

Here's how:

In your company, head to the Banking menu in the left navigation bar and choose the Banking tab.
Under the For Review tab, tick the boxes for the transactions you wish to remove and select the Exclude button.
The entries will move in the Excluded tab of the Banking page.

For more information into this process, click here for the complete details. It includes instructions on how to perform the action using the mobile app.

Also, QuickBooks will automatically match your transactions once it detects entries with similar amounts and details. This links them together, so you don't get duplicates. For detailed instructions, see the following reference: Categorize and match online bank transactions in QuickBooks Online.

I've included an article that will help you keep your records balanced and accurate: Reconcile an account in QuickBooks Online. For tips to accomplish your accounting tasks on time, feel free to browse the Community page. From there, you'll learn how to manage your cash flow, troubleshoot banking issues, and perform other tasks related to QuickBooks..

Keep me posted if you have other questions or concerns about matching your transactions. I'm always ready to assist you further.

View solution in original post

Rasa-LilaM · ‎February 24, 2023

Let me point you in the right direction direction on how to resolve your concern, PinkyK.

We'll have to exclude the duplicate entries. Then match the downloaded transactions to your bills to keep your records in order.

Here's how:

In your company, head to the Banking menu in the left navigation bar and choose the Banking tab.
Under the For Review tab, tick the boxes for the transactions you wish to remove and select the Exclude button.
The entries will move in the Excluded tab of the Banking page.

For more information into this process, click here for the complete details. It includes instructions on how to perform the action using the mobile app.

Also, QuickBooks will automatically match your transactions once it detects entries with similar amounts and details. This links them together, so you don't get duplicates. For detailed instructions, see the following reference: Categorize and match online bank transactions in QuickBooks Online.

I've included an article that will help you keep your records balanced and accurate: Reconcile an account in QuickBooks Online. For tips to accomplish your accounting tasks on time, feel free to browse the Community page. From there, you'll learn how to manage your cash flow, troubleshoot banking issues, and perform other tasks related to QuickBooks..

Keep me posted if you have other questions or concerns about matching your transactions. I'm always ready to assist you further.

Topics

Training

Community

Resources

Create a bill for my credit card statement, pay multiple times, then matching in bank feed

Create a bill for my credit card statement, pay multiple times, then matching in bank feed

Create a bill for my credit card statement, pay multiple times, then matching in bank feed

Need to get in touch?