cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

bill with an open balance greater than bill amount

There was a vendor where the bill amount was $100. The bill date is 6/30/2014 and the due date is 7/1/2014. The payment was made on 7/25/2014. However, in the payment page, it showed original amount as $100, open balance as $200. When I paid $100, the AP went away on my balance sheet, but there was $100 remained outstanding on AP Aging. On the vendor summary, it shows open balance as 0, overdue balance as $100. Thus, I have a different amount on AP Aging and AP per Balance sheet. What is causing the situation and how can I get it fixed? Why was open balance greater than original bill amount?

5 Comments
Highlighted
Level 15

bill with an open balance greater than bill amount

You entered a bill in QB, when you do so and it is time to pay it, you need to use pay bills to associate the payment with the bill, it sounds like you did not do it that way.

 

edit the payment and as the expense change it to accounts payable, save
then open pay bills, select the bill and apply the credit the edit made

Highlighted
Level 1

bill with an open balance greater than bill amount

It is charged to Accounts Payable and to that bill directly. The thing is I am not sure why the open balance doubled  from the bill amount in the payment page with no additional expenses and accounts payable shown in the GL. Currently the payment page is shown as below:

Payment amount: $100

Description: Bill #xxxxx

Due date: 7/1/2014

Original Amount: $100

Open Balance: $200

Payment: $100

 

Highlighted
Level 15

bill with an open balance greater than bill amount

run a vendor detail report and look for a bill with no payment or a journal entry

Highlighted
Level 10

bill with an open balance greater than bill amount

"There was a vendor where the bill amount was $100."

 

You may want to open this vendor bill and check Account used to record this bill.

Once the bill is open, click "More" at the bottom and select Transaction Journal.

 

You can also run the "Bills and Applied Payments" report in QBO. This report will show vendor transaction details.

 

 

Highlighted
Level 1

bill with an open balance greater than bill amount

The weird thing about this transactions is that in the General ledger, only 100 was recorded as expenses, and there is no accounts payable remaining outstanding in the balance sheet. However, in the AP Aging, 100 was remained outstanding (200 open balance - 100 payment). That's how account payable as of a certain date per the AP Aging and AP on the Balance Sheet do not agree. I am not sure how that could happen for the open balance to be over by 100 but never shown on the GL. Is there anything to do with overdue status? The bill is entered 6/30/2014, due date is 7/1/2014, and payment is 7/25/2014.

Need to get in touch?

Contact us