Small and medium business | Business Central, N...

Reconciliation Negative Deposits

(0) Share

Report

Posted on by Jackie L

We are experiencing vendor payments made through a Payment Journal appearing as a negative deposit when reconciling. I’m trying to pin-point why this might be occurring. We typically process vendor payments through QuickPay, but when we are paying multiple invoices with one payment, we use the Payment Journal. In the Payment Journal we do not use the balancing account since we are paying multiple invoices.

Edit to include - It appears that transfers between bank accounts have a similar issue. The withdrawal also appears as a negative deposit. These are processed through the cash receipts journal.

Any thoughts?

All responses (6)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Do you remember to apply the payments when you post them through the journal?
Jackie L 30 on at

Like (0)

Report
Copy link

Link copied!

Yes, the payments are being applied.

I’ll edit the post to include this – but it appears that transfers between bank accounts have a similar issue. The withdrawal also appears as a negative deposit. These are processed through the cash receipts journal.
IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

So there are no open amount on the entries?

How do you define "negative deposit" maybe it is getting lost in translation for me.
Jackie L 30 on at

Like (0)

Report
Copy link

Link copied!

No, the purchase invoice is closed.

One the reconciliation report the payment reflects under the deposit section but is negative.

Thanks!
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Jackie,

Adding to this thread... So you create a Payment Journal that will pay Vendor documents (i.e. Invoices) and on the Payment Journal the Document Type = Payment. You pay these via Electronic or Check. You enter the Balancing line or BC, when it cuts the Check?

Please email back what you do and maybe an example.

Thanks,
Steve
Jackie L 30 on at

Like (0)

Report
Copy link

Link copied!

We enter a balancing line, just as you have in batch the screenshot.

So we do not print checks from the system. We are processing these payments via ACH, however BC is not connected to our banking platform. We select “manual check” when processing them through Vendor Quick Pay.

I think this may be where the issue is arising. The team has not been selecting anything in the “Bank Payment Type” field. I’m having them test it with this month’s reconciliation process to see if selecting “Manual Check” resolves this.

The response we got from our consultants was that this is how the system does reconciliations but I'm very doubtful that this is the case.