How can I reconcile a partial amount of opening positive balance to an invoice for BP?

[Sara8]

Hi all, 

I have a business partner for which there was an opening balance of 30 Euros. This is a payment we had done for the supplier to keep it on account since we are always purchasing small amounts from them. So basically every invoice issued is of 2 Euros in this case and we need to reconcile each time by deducting 2Euros from the opening balance. 

When I try to reconcile a partial amount of the OB to the invoice the balance instead of showing 0 it shows as -4. It keeps adding instead of deducting. If I try to insert a negative amount in the OB amount to Reconcile it doesnt allow me. 

Can someone help me please?

[SonTran · Accepted solution]

Hi,

It looks like the opening balance is in Credit Side, It is the reason you can not reconcile to AP Invoice.

Please check again.

Hope this helps,

Son Tran

[Sara8 · Accepted solution]

Hi Son, Thank you for your reply, Would you be able to suggest a way to move forward? How can I reconcile our purchases to the credit we have in their account?

[SonTran · Accepted solution]

There is no way to reconcile two credit transactions. The reconciliation works only for a debit and credit side.

The advance payment to vendor must be posted as following:

Debit Vendor

Credit Bank/Cash

I suggest to adjust the opening balance first, then you can do reconciliation as usual.

[Sara8 · Accepted solution]

Thank you very much Son for the explanation!