FrontAccounting forum — Compare automatical incomming /outgoing payments with invoices

Re: Compare automatical incomming /outgoing payments with invoices

null@example.com (itronics) — Sat, 23 Nov 2013 15:16:14 +0000

Yes, I know the standard. But for some reason banks preffer to force their own formats, and name them MT940, but those proprietary formats have not much to do (if at all) with MT940 standard.
Janusz

Re: Compare automatical incomming /outgoing payments with invoices

null@example.com (apmuthu) — Thu, 21 Nov 2013 16:13:04 +0000

SWIFT MT940 Customer Statement Message (1.5 MB PDF)

Re: Compare automatical incomming /outgoing payments with invoices

null@example.com (itronics) — Sun, 10 Nov 2013 15:29:55 +0000

Unfortunately this functionality cannot be implemented as a generic module. Despite the fact MT940 standard exists, I do not know two banks which use the same format for bank transactions listings, seems every one developer working for feels the urge to design the wheel again. Therefore I guess you will have to hire some php coder to implement the feature for you and make your life easier.
Janusz

Re: Compare automatical incomming /outgoing payments with invoices

null@example.com (apmuthu) — Thu, 07 Nov 2013 12:17:26 +0000

Probably the right description you were after was Automatic Allocation Reconciliation

Re: Compare automatical incomming /outgoing payments with invoices

null@example.com (elax) — Thu, 07 Nov 2013 12:10:43 +0000

I've made a report which display customer statement in a similar way as a bank statement (just showing the balance by time) and ignore the payment allocation. That way, you can just allocate on payment on the fly and don't need to know which payment correspond to which invoice. (This is what I usually do).

/Elax

Re: Compare automatical incomming /outgoing payments with invoices

null@example.com (tm) — Thu, 07 Nov 2013 12:04:57 +0000

I don't know of any module, but if you have a (machine readable) file from the bank, containing some identifier (invoice or reference number) which could be looked up and matched against a particular order, you could query the database and generate the required transactions automatically. Either through some API or directly against the database. There's a module to import CSV data, which I use to import sales figures through a curl session.

It seems to support importing deposits, but I don't know how (or if) it can be made to allocate the payments to invoices.

Compare automatical incomming /outgoing payments with invoices

null@example.com (wildone) — Thu, 07 Nov 2013 11:08:28 +0000

When you have more then 2000 payments per month it takes too much time to compare each payment with your sell and purchase invoices.

Is there a possibility or module that compares incoming/outgoing payments automatically with invoices?
And if there are deviations you can select possible customers / suppliers from the list of open invoices?
After comparison only the not compared items are still open. The rest is booked internal in FA.

In Holland we call this utility: automatisch afletteren. But I can not find a good translation for this.
Maybe: Allocated payments.

This would reduce much hours each month.

Regards,
Ronald