I suggest you ...

Create a FAQ Sheet about the column formats when uploading bank transactions from a CSV file

I had a few problems when I tried to upload bank transactions from a CSV file.

- The date column had to be formatted to dd/mm/yyyy
- The debit and credit columns had to be formatted to number to remove any ","
- Any zeros had to be removed from the debit and credit columns
- The balance columns had to be deleted

There is no way ppl will remember how to format the CSV files correctly.

I think it will be good if you create a FAQ Sheet about the formatting requirements in the CSV files.

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base