Uploading PayPal CSV files to Wave

Ellie_Writes_ThingsEllie_Writes_Things Member Posts: 42 ✭✭

Hi Wavers!

Does anyone have experience with uploading the CSV statements from PayPal into Wave? I'm trying to wrap my head around how to format this right. Which columns am I supposed to remove?

Also will I be able to handle the PayPal fees on there?

Comments

  • BoogaBooga Member Posts: 8

    A question I too would love to know. Mind you, you've been waiting since May so I am not sure we'll get a response. The help article suggests that you need to strip it down to just date, debit/credit (can be in 2 columns) and description. Which for me is too little information. If you can get the integration to work you get all of the information, which is useful if you want to categories the transaction. I'd like to know if we can add more of the information and if so what. My last effort fell at the first hurdle when I get the multiple currency error.
    I really baffles me as to why this isn't better explained or why the PayPal integration is so poor.
    It's a real issue for me as the vast majority of our transactions are through PayPal and it's the reason I haven't really fully got on board with using Wave.

    https://support.waveapps.com/hc/en-us/articles/208622596-What-to-do-if-Wave-can-t-read-your-statement-in-CSV-format

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Hi, @Ellie_Writes_Things and @Booga,

    I'm more than happy to break it down for you both. Turning a PayPal history CSV into one that will upload to Wave should only take a few minutes. Here's what you have to do:

    • Copy the Amount, Description and Date columns into a new spreadsheet.
    • Copy the merchant fee column at the bottom of the Amount.
    • Copy the Date column again and paste it again at the bottom of the Date column. The order of your merchant fee column should match the order of the dates already if nothing was moved around.
    • As a description for your merchant fee transactions, just put in "PayPal Fee", and copy it next to every merchant fee transaction.

    At this time, Wave doesn't have a simple way to handle PayPal accounts that operate in multiple currencies. You would have to separate your transactions by currency and upload them to different PayPal accounts, each with different currencies. Wave's support for businesses who use multiple currencies has improved in the recent past, multi-currency support is still limited.

    We are aware of the issues with the PayPal integration and we know what kind of impact a more stable PayPal integration could have on our users. While I can't promise a timeline for improvements to this integration, I can tell you that we are paying attention to feedback from our users. Thank you for taking the time to offer yours.

    edited October 5, 2018
  • BoogaBooga Member Posts: 8

    @Alexia thank you very much for the response and clear instruction.
    Essentially wave doesn't care about having a sequential date it just looks for an amount and the date against it, hence stacking the credits and debits in one column.
    I will give this a go and once again, thank you for your help. :smiley:

  • AlexiaAlexia Administrator Posts: 3,315 admin

    Happy to help out!

  • BoogaBooga Member Posts: 8

    @Alexia
    This completely worked for me. Don't worry too much about column order, you get to confirm what is in what column during the upload process.
    You will need to add a transaction (Deposit) that is your opening balance if this is your first upload. You can do this once you have uploaded your first statement.

  • mostlydevmostlydev Member Posts: 5

    I wrote a little ruby script that does this. It also breaks up PayPal CSV files into one for each currency and renames the columns.

    https://mostlydev.com/importing-paypal-csv-into-wave-accounting/

    Instructions for use and links are inside the post.

    Update 2019-02-11
    Some people asked, so I've made a little web utility for the less savvy but equally frustrated.
    https://mostlydev.com/make-waves/

    edited February 11, 2019
Sign In or Register to comment.