Partial Payment On Invoice

[tomtheriault]

Hi, we have developed an invoice system on a database and we invoiced a customer: Sub Total of $3,210.00 + 13% tax ( 417.30 ) for a Grand Total of $3,627.30.

The customer did a partial payment of $3000.00 dollars many months ago!!

Due to forces beyond everybody's control the remaining balance of $627.30 will never get paid :-(

We've decided to adjust the invoice so that the invoice Sub Total of X + 13% will equal the Grand Total paid of $3000.00 dollars.

Since we have to pay tax on the amount received, I have been unsuccessful in determining the sub total value. I thought I could just subtract the difference and recalculate the tax due but it didn't work. My calculation is determined on the end total not the unknown sub total. I even tried to manually enter in different amounts and the best I could get was an entry of -555.09 which left a .06c balance due approximately.

Anyway, is there a formula I can write into a calculation for these types of partial paid invoices where we have to zero out the remaining balance due ???

I need to find the new Sub Total of the $3000.00, then I can calculate the tax % for a Grand Total of $3000.00

Any assistance here I would be grateful.

Thank you

Tom

 

[lev888]

Hi, we have developed an invoice system on a database and we invoiced a customer: Sub Total of $3,210.00 + 13% tax ( 417.30 ) for a Grand Total of $3,627.30.

The customer did a partial payment of $3000.00 dollars many months ago!!

Due to forces beyond everybody's control the remaining balance of $627.30 will never get paid :-(

We've decided to adjust the invoice so that the invoice Sub Total of X + 13% will equal the Grand Total paid of $3000.00 dollars.

Since we have to pay tax on the amount received, I have been unsuccessful in determining the sub total value. I thought I could just subtract the difference and recalculate the tax due but it didn't work. My calculation is determined on the end total not the unknown sub total. I even tried to manually enter in different amounts and the best I could get was an entry of -555.09 which left a .06c balance due approximately.

Anyway, is there a formula I can write into a calculation for these types of partial paid invoices where we have to zero out the remaining balance due ???

I need to find the new Sub Total of the $3000.00, then I can calculate the tax % for a Grand Total of $3000.00

Any assistance here I would be grateful.

Thank you

Tom

X is the amount before tax.
Tax amount is 13% of X, which can be written as what?
The total is X + ... = 3000. Solve for X.

 

[Steven G]

I am in a good mood tonight. Let x be the amount charged before tax. So you want x + .13x = 3000. That is 1.13x=3000. So x= 3000/1.13

 

[tomtheriault]

Thank you