cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Tracking back from Bill Pay entry

I use Bill Pay which works for entering and paying.

My problem is backtracking from Bill Pay to the Enter Bills entry. I have a few instances where Bill Pay aggregates the payments. I am OK with that. But during reconcile I get stuck not knowing how to trace back from the Bill Pay entry which is accounts payable to the original entries in the expense accounts.

Thank You

Marlin

4 Comments
Highlighted
QuickBooks Team

Re: Tracking back from Bill Pay entry

I'll give you two scenarios to help you handle this, Marlin.

 

If you use Bank Feeds to match the bill payments with the bills, you'd have to manually mark the bills as paid. Then, proceed with the reconciliation.

 

Here's how:

  1. Click Banking at the top.
  2. Click Bank Feeds, and then select Bank Feeds Center.
  3. Choose the account that you're trying to reconcile.
  4. Click the Transaction List button.
  5. Check the bill payments on the list.
  6. Under the Action column, click the Select drop-down.
  7. Choose Select Bills to Mark as Paid.
  8. Enter the Vendor and the Account.
  9. Click Add to QuickBooks.

Once you go back to the reconciliation page, you can select the Matched option. This way, the transactions that fall on the date you entered will be checked automatically. Take note that these are the entries that you've matched in the Bank Feeds section.

 

Like this:

  1. Click Banking, and then select Reconcile.
  2. Enter the Ending Balance.
  3. Click Continue.
  4. Click the Matched button.
  5. Enter the Statement Ending Date.
  6. Click OK.

But if you don't do this, then you'd have to ensure that the amount and the date of the transactions matches your bank statement.

 

Just leave a reply if you have a few more questions about reconciling in QuickBooks. We'll be here to help you some more.

Not applicable

Re: Tracking back from Bill Pay entry

Thank You

I don't use bank feeds yet.

I also am doing fund accounting using sub bank accounts for my funds. Which gets to my issue. When Bill Pay aggregates payments I lose track of which funds were used. This effects my reconcile.

Many of the entries I am to separate and post individually so I can reconcile them. Yes it complicates reconcile. I have been able to find manageable ways to do the reconcile except when the aggregated payment shows up in accounts payable and I don't how to find the original expense accounts used.

Thanks You

Not applicable

Re: Tracking back from Bill Pay entry

hank You

I don't use bank feeds yet.

I also am doing fund accounting using sub bank accounts for my funds. Which gets to my issue. When Bill Pay aggregates payments I lose track of which funds were used. This effects my reconcile.

Many of the entries I am to separate and post individually so I can reconcile them. Yes it complicates reconcile. I have been able to find manageable ways to do the reconcile except when the aggregated payment shows up in accounts payable and I don't how to find the original expense accounts used.

Thanks You

Moderator

Re: Tracking back from Bill Pay entry

Thanks for getting back to us, @mturbett.

 

I want to make sure that I'm on the same wavelength, are you referring to the bill showing the total amount of the bill payment on the reconciliation page? If so, run a report to check the expense account used for that specific transaction.

 

In this case, let's use the Transaction List by Vendor report. Here's how:

 

1. Go to the Reports menu at the top.
2. Pick Vendors & Payables and Transaction List by Vendor.
3. Click the Customize Report option at the upper left.
4. Go to the Filters tab.
5. On the Choose Filter section, select the following:

  • TransactionType - Bill.
  • Paid Status - Closed.

71.PNG 72.PNG

6. Hit OK.

 

Once done, you should be able to see the expense account used on the Split column.

73.PNG

 

Just in case, I'm also including these articles for additional resources:

 

 

That should answer your concern for today. Please let me know how it goes or if you're referring to something else. I'll be here to help. Have a great day.

Need to get in touch?

Contact us