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?
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
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
"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.
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.