Accounting Ideas

Import bank payments

We make a number of grant awards each day, that are not paid until one or two days after award. We record them in the accounts with the date the award is agreed/request raised. In Sage50 we could import a file with this detail.
We have tried different methods.

  • Manual entry, this take far too long for the number of awards we make.

  • Create via bank import or bankfeed they are recorded on day of payment and not day of payment request and each required the analysis split to be added.

  • Journal entry this takes time to set up and requires double the number of lines to be able to record each award separately in the n/c and bank, add analysis split. This is the best method so far.

  • Guest
  • Jul 21 2023
  • We're Taking A Look At This
  • Attach files