Add a new idea Subscribe
Status New idea
Workspace Reckon One
Categories Accounting
Created by Guest
Created on Sep 29, 2019

RELATED IDEAS

Ability to import from Excel payments received

We are a basketball club, we rely on volunteers.  We moved to reckon to reduce volunteer hours and improve our accounts management.

We have registrations twice a year - this creates copious number of bank transactions.  We are able to report the corresponding entries from the system (currently SportsTG) we use to receive the payments in an excel spreadsheet.  It would be great if these could be then imported into Reckon for matching with the bank transactions rather than having to manually data enter the entries (a very time consuming task as each transaction has up to 4 entries (due to costing splits of income and expense).  We have tried to limit the registration period to reduce the number of entries.

It seems crazy, that we have to run a report in one system and then manually enter the information into another.

  • ADMIN RESPONSE
    Sep 29, 2019

    Although we do have plans to eventually have this functionality there is not a high demand at the moment.

    As Sports TG manages your subscriptions (who owes what for what) an Reckon One is accounting software, would it be possible to use your bank feed / bank file import to enter the MONEY IN (not linked to a subscriber) as we would agree, managing debtors / subscribers in 2 systems isn't optimal.

    We'd also be happy to talk to Sports TG about an integration if you can put us in touch with a contact as this would be much cleaner than an excel import / export.

  • Attach files
  • Guest
    Reply
    |     Sep 30, 2019

    Hi Jason,

    We don't manage the debtors in both systems - but import information about the type of income eg. membership fees, uniform merchandise purchase and prepaid scoresheet fee income plus the STG fees deducted. So not on a debtor by debtor transaction but based on the feed into our bank account from STG.

    So we do use the Reckon One bank file import to enter the MONEY IN (not linked to a subscriber) but we still need to allocate these transactions into the various income and expense amounts in Reckon One as this is where we report our income etc. So more often than not, each transaction is split into 4 allocations.

    I don't think integration with STG would be the solution. I would prefer the upload from a file option for many reasons. Happy to discuss by phone, if you can call.

    Thanks

    Trish