Pay Pal Integration: multiple starting balances?

MEFinamore

hi~ my paypal integration seems to have finally "stuck" now, however, every time i added it before, it created a new starting balance for paypal... so, overall looks like i have a lot more money than i actually do. how do i correct this?
thank you!

Samd

Hey @MEFinamore! Unfortunately there isn't a super straightforward way to simply merge the information from these two (or more) accounts, but I can definitely help you get this sorted out. Though I'll mention at the offset that if it was just the starting balances that duplicated, the quickest option would be to delete just the starting balances transactions (you should be able to do this via Accounting > Transactions, and narrow down to the PayPal accounts).

In terms of getting this sorted for the account/transaction duplications, what you'll want to do first is go to your Accounting Tab > Chart of Accounts, and click the pen icon to the right of one of those duplicate accounts, then just add a distinguishing feature (eg. Account1) so you can tell the two apart. Once this is done, go to your Transactions page and filter for each Account in order to figure out which is the currently active connection (the one with the most recent transactions).

You then will have two options for transferring all the information from the old account to the new one.

1. You can filter your Transactions screen by the old account, then manually change the account on each transaction to be listed as the new account. You can do this by clicking the transaction Account dropdown to change it to the new PayPal account.

2. If you have many transactions in the old account and changing each individually sounds wholly unappealing, you can instead filter by the unwanted account then click the box to the left of 'Date' to select all associated transactions then Delete. You would then want to manually upload a statement for that specific date range, ensuring that when you upload the statement you are choosing the desired Account to have them listed under!

If you choose the second option, a couple things to keep in mind is that the system will only want to see 3 columns in the file you are uploading; Date, Description, Amount where expenses will be shown with a negative sign in front of the amount value (unless it is a Credit Card statement, in which case you'll want to make payments to the credit card with a negative sign!) and Dates will be formatted as mm/dd/yyyy.

Here is a basic example of this format:

01/01/2018, Description 1, -250
01/02/2018, Description 2, 550.50
01/02/2018, Description 3, -120.75

Once you have all your transactions successfully associated with the currently active account you will be able to go to the Accounting Tab -> 'Chart of accounts' and click the trash can icon to the right of the unwanted account to delete it from your Wave profile. I hope this helps to clarify, and my apologies about the messiness of the workaround!