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

How to Record Projected & Actual invoices

Hello,

 

I'm trying to figure out how to record these invoices that I have that involve both a projected amount and how to record the actual amount for our purchase of service. 

 

The projected amount we pay using estimated data so the break down would be something like.

 

Covid Hazard Pay - xx, xxx

Purchase of Service - xxx,xxx (using state funds)

Total = 316,709.65

That's pretty simple but then we get our actual data that has the breakdown of info that we need to show in our expenses

 

Purcase of service - xxx,xxx

Covid expenses - xxx.xx

Receivables (xxxx.xx) (these get deducted from vendor)

Total = 315,548.31

 

We have a remaining balance due of $1,161.34

 

Does anyone know how this would get recorded? We obviously cut the check for the projected amount, but then we receive the actual data and is confusing as to how to record the expenses such as the actual purchase service amount, our covid expenses, etc. I always end up with an negative number in my bill and have to figure out where to take it out from and record the credit and has messed up our purchase of service line in the P&L.

 

Any assistance would be appreciated.

1 Comment 1
BigRedConsulting
Community Champion

How to Record Projected & Actual invoices

If you paid 316,709.65 and then later received an A/P invoice for 315,548.31, it seems you have overpaid and you have a credit of 1,161.34 - an amount more or less due back to you.

 

In that case, if you have another A/P invoice coming from the same vendor, usually you'd apply the over-payment credit to the next invoice, or if not get a refund from the vendor.

 

Can you clarify the case?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us