Not importing the "Fee" column on CSV file

1

I’ve been using an older version of Manager for the past couple of years and when I downloaded my Stripe transactions as a CSV the headings would be: Date, Description, Reference, Gross, Fee, Net

When I would use the “Import Bank Statement” option, Manager would know to include the “Fee” line on as part of the transaction (it would add the line for it). For example, a sale for $100 would look like this: Gross= $100, Fee=$10, Net=$90.

Now I’m using the latest version of Manager and when I import the CSV file it only imports the “Net” column and ignores the Gross and Fee column.

The other way I would import would be to just have the Gross & Net columns in the CSV and Manager would calculate the difference as the fee and include it.

How do I fix this so that I’m importing the Fee column?

Thank you.

2

My understanding is bank import does not import multi part transactions directly. To do so you could

  • create a bank rule which separated the out the fee (constant amount or constant percentage)

  • used batch create instead to import the transactions

3

Thanks for your reply, Patch.

In the older version you used to be able to import multi lines, but it looks like you can’t do it in the newer versions.

I was thinking of using the bank rule option to create the fee. The only thing is, Stripe will round the cents. Can this be done in the rule settings? Because I know what the fee percentage is, I just need it to round up, to match the actual fee Stripe charges.

Also, I was thinking of just taking the total fee charged as a single figure and importing that, rather than all of the individual/itemised fees. It’s probably not technically correct to do it this way, but it would be correct on my P&L. Or should I not do it this way?

Thanks again.

4

Bank rule Fee percentage plus a reconciliation with the total / journal rounding correction sounds easiest to me but it is your call.

5

Ok, thanks for your help. I appreciate it.