matching transactions without duplicating

  • 1
  • Problem
  • Updated 2 years ago
I have been reading through posts and it seems that there is no manual matching method where the auto matching doesn't pick up a transaction. Is that right? If so how do you match the bank to ledger transactions without having to create a duplicate transaction?
For example, say my invoice to my customer is $100, they pay $100 therefore that's what goes against their account and to the bank gl. Stripe, the online gateway, passes on the payment less their fee, say $99 comes through. A second transaction for $1 to fees has to be created. Manually you would match the payment and offsetting fee together against the $99 payment. Auto matching won't do it so how on earth can I complete a bank rec?
Photo of Digna Gobaira

Digna Gobaira

  • 70 Points
  • frustrated

Posted 2 years ago

  • 1
Yes I am suffering from the same issue. Auto matching seems to be glitchy as hell. I've spent a lot of time on the phone to support and tbh they are bloody useless. One guy was telling me it wouldn't auto match until a transaction rule is set up however that is to create a new payment/receipt etc not allocating to an existing payment as you have mentioned...Please advise.
Photo of Reckon FAQs

Reckon FAQs, Employee

  • 10,158 Points 10k badge 2x thumb
Hello Digna and Studion Twelve Architecture,

Payment gateways that deduct their fee from the payment to you do provide a challenge for Reckon One as they are introducing another transaction into the equation.

The integrated PayPal payment service has a solution for it (Settings > Payment Services)

For other scenarios - other gateways, manual uploads from PayPal - please look at our guides:

Manually Importing PayPal transactions

Manually Importing PayPal fee transactions.

Hope these guides prove useful.