Import transactions from Excel

I have been keeping a complete list of my transactions in excel. I have few years worth of bank statements, and credit cards, etc. Is there anyway to import my data from excel?

  1. I'm sorry, there isn't an import function in the app because of all the variations in formats I would need to support.

    What I could suggest is creating a set of accounts that match what you need and setting the opening balances at a certain date. Then perhaps run the two systems in parallel for a while until you're happy you have it set up right. I did this when I moved over from my old bookkeeping package to Easy Books in 2009.

    I hope that helps,
    Mathew

  2. Admin closed this discussion on 14 Jul, 2011 01:47 PM.

  3. Karaca Kestelli re-opened this discussion on 20 Jul, 2011 06:32 AM

  4. Hi Matthew,

    First of all thanks for prompt reply.

    However, there's one thing I don't understand: why don't you define your own format, and we as users comply with your import format. e.g. a cvs format maybe?

    In terms of your suggestion, I don't want to lose my 5+ years of data for comparison purposes.

    Thanks, rgards,

    Karaca Kestelli

    [email blocked]
    www.kestelli.com
    +90(532)337 7670

  5. Hi Karaca,

    That's a good suggestion, I will add this to the list of things to do, but I'm busy on the Mac OS X version for the next few months so I'm afraid it's going to be a little wait.

    Mathew

  6. Admin closed this discussion on 21 Jul, 2011 09:50 AM.

Discussions are closed to public comments.
If you need help with Easy Books please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions