Do we have any QuickBook gurus on here?
I would like to know if QB can do the following.
Allow the importation of a PayPal transaction log file (I see PayPal does allow the QB format).
Allow for multiple currencies
Allow for splitting the transactions to multiple sub-accounts.
For an online organization I belong to we have been using Excel and a custom build software application called JustCash (was created by a member of ours who is no longer with us) to keep track of our finances.
This is what we have and what we need tracked.
2 PayPal accounts (a main account and a micro transaction account)
All expenses go out via our main account.
Each PayPal account have 4 currencies right now (USD, GBP, EUR, and AUD)
In JustCash we then separate the paypal transactions to 21 sub-accounts.
(For example: Battlefield (BF), FarCry, Counter Strike, etc..)
So if a donation is for BF JustCash assigned the donation + the PayPal fee of that donation to the BF sub-account.
Each sub-account tracks all 4 currencies.
There is also an overall tracker that adds up all the currencies for each sub-account.
So once a week when we pull the PayPal transactions log and balance our books the JustCash overall tracker should match with what PayPal shows as our current balance.
Does this make sence?
Is there a way to do this in QB 2014?
When we looked at QB back in 2008 it was not possible at that time to track multiple currencies and I don't think it was able to do sub-accounts either. So not sure if this has changed or not and/if anyone has experience in doing this or could offer their services in setting it up.
Thanks
I would like to know if QB can do the following.
Allow the importation of a PayPal transaction log file (I see PayPal does allow the QB format).
Allow for multiple currencies
Allow for splitting the transactions to multiple sub-accounts.
For an online organization I belong to we have been using Excel and a custom build software application called JustCash (was created by a member of ours who is no longer with us) to keep track of our finances.
This is what we have and what we need tracked.
2 PayPal accounts (a main account and a micro transaction account)
All expenses go out via our main account.
Each PayPal account have 4 currencies right now (USD, GBP, EUR, and AUD)
In JustCash we then separate the paypal transactions to 21 sub-accounts.
(For example: Battlefield (BF), FarCry, Counter Strike, etc..)
So if a donation is for BF JustCash assigned the donation + the PayPal fee of that donation to the BF sub-account.
Each sub-account tracks all 4 currencies.
There is also an overall tracker that adds up all the currencies for each sub-account.
So once a week when we pull the PayPal transactions log and balance our books the JustCash overall tracker should match with what PayPal shows as our current balance.
Does this make sence?
Is there a way to do this in QB 2014?
When we looked at QB back in 2008 it was not possible at that time to track multiple currencies and I don't think it was able to do sub-accounts either. So not sure if this has changed or not and/if anyone has experience in doing this or could offer their services in setting it up.
Thanks