Accounts Hosted Bank Data / Reconciliation : Matching one single transaction (aba file debit) to multiple bill payments

  • 4
  • Question
  • Updated 4 months ago
  • Answered
Hey guys - question for your gurus out there.  Accounts Hosted Bank Data Feed...

When I lodge an ABA file, it shows up in the bank transaction listing as one single payment - when it comes to reconciling this single payment against the fistful of bills that I've paid - how do I go about splitting the one statement line across the multiple "cheques" written?

Or - alternatively.....

Can we tweak a setting somewhere in the black magic box that is Accounts Hosted and have the ABA File tell the bank account to list each line item on the transaction list?

What is the best way forward here?
Photo of Peter Leech

Peter Leech

  • 162 Points 100 badge 2x thumb
  • confuddled

Posted 4 years ago

  • 4
Photo of Shannon Sciuto

Shannon Sciuto

  • 2,110 Points 2k badge 2x thumb
Hi Peter, 

Ideally, Reckon would recognise that a single ABA file exported would be recorded as a single outgoing transaction in the reconciliation (as MYOB and QBO do) but we can't have everything I guess. 

Kelly had a good solution here using a clearing account that might help you. https://community.reckon.com/reckon/topics/bankdata-how-do-i-match-a-single-transaction-deposit-with...

I believe there is also a way in the feeds to match one payment to multiple transactions but I don't use Reckon feeds so I can't help you there sorry!!  Maybe someone else can help? 

Cheers, 

Shannon. 
Photo of Kylie Martin

Kylie Martin

  • 190 Points 100 badge 2x thumb
HI Peter, Did you find a solution to this as it is annoying me too
Photo of Prue Dickins

Prue Dickins

  • 62 Points
Has this been fixed or a simpler workaround as I have unmatched transactions for multiple bills paid and I do not know how to make it all work. Creating a clearing account is not helpful.