How do I mark an invoice as paid?
A customer purchased a product from us for £xxx.xx and paid by PayPal. The payment from PayPal, minus PayPal fees was withdrawn into our account at the moment the product was sold.
If I create this customer as a "Client" and create a "Project" and a single "Invoice" for them, I can't seem to see a way to move from Draft to Paid - it's almost as if FreeAgent is trying to force me to send the invoice by email before I can change status t paid.
Furthermore - how do I set the line in my bank statement for this revenue to the invoice and account for the cost of sale difference?
Many thanks,
Mike
If I create this customer as a "Client" and create a "Project" and a single "Invoice" for them, I can't seem to see a way to move from Draft to Paid - it's almost as if FreeAgent is trying to force me to send the invoice by email before I can change status t paid.
Furthermore - how do I set the line in my bank statement for this revenue to the invoice and account for the cost of sale difference?
Many thanks,
Mike
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
The best answers from the company
-
Hi Mike,
We'll aim to get the changes to Paypal accounts ready for the next release, scheduled for next Monday.
Once you import the Paypal statement into FreeAgent, you will see each unexplained transaction. Just click on one to explain a transaction as an Invoice Receipt. The invoice in question (assuming the amounts are indeed the same) will then automatically be marked as Paid.
Regarding Google Checkout, we don't (yet) have an account but it seems they do allow all the order data to be exported using the 'Download data to spreadsheet (.csv)' option. Would you be able to check to see if this contains Gross, Net and Fee information as the Paypal statements do?
Thanks for the heads-up on World Pay.
The company says
this answers the question
-
If you're uploading bank statements then rather than manually marking the invoice as paid, you should explain the unexplained bank transaction as an Invoice Receipt.
If the unexplained transaction amount was the same as the invoice total then the invoice would automatically be marked as Paid. In your case, since the transaction amount is LESS than the invoice total (due to the Paypal fee), then the invoice remains in a Sent state. However at this stage you can simply click the WRITE-OFF UNPAID button which will do exactly what you want!
This is certainly a valid workaround for your situation, but using a separate Paypal account would provide a fully accurate model of your finances. It shouldn't take up much more of your time than your current process -- it's really simple. In fact, it may even save you time because FreeAgent gradually learns more about your explanations and will start to automatically explain them for you (where possible) when you upload your statements.
We'll look into supporting Google Checkout. Are there any other payment mechanisms you use in addition to these two?
The company says
this answers the question
-
Hi Mike,
To mark an invoice as paid you have to first mark it as Sent. You can do this by either sending it in an email or by clicking on the green arrows (>>) pointing from Draft to Sent. This will move it from a Draft state into a Sent state.
To mark a Sent invoice as Paid you have two choices. You can manually do this by clicking on the green arrows (>>) pointing from Sent to Paid. You will then be asked to manually add a bank account entry and select an invoice to allocate the money to. Alternatively, if you are uploading your bank account statements, just click on the unexplained transaction which relates to the invoice payment, select Invoice Receipt as the transaction type and then select the invoice to allocate the money to.
However, given the Paypal scenario you describe, you might want to take a different approach -- one we use for FreeAgent Central's accounts in fact.
You should first add a new Bank Account to FreeAgent which represents your Paypal account (you'll have to make up a sort code and account number for now -- we don't explicitly model Paypal accounts just yet).
Next, from the Paypal website you can download all your transaction data in CSV format (they say they support QIF, although we're finding that it isn't actually available at present) and then upload this statement into your newly created FreeAgent Paypal Bank Account. This would allow you to explain the actual Paypal transactions against the invoices and then explain the transfers between Paypal and your Bank Account as transfers in FreeAgent.
One caveat. At present we only import the NET amount from the Paypal CSV file, not the GROSS amount, which would still leave you with a disparity between the transaction amount and the invoice amount. However, we can make a change for next week's FreeAgent release so that both the gross transaction and the Paypal fee are listed as separate transactions. This would allow you to fully model all the money in and out of both Paypal and your bank account.
Would this be a viable solution for you?
The company says
this answers the question
-
Inappropriate?Hi Mike,
To mark an invoice as paid you have to first mark it as Sent. You can do this by either sending it in an email or by clicking on the green arrows (>>) pointing from Draft to Sent. This will move it from a Draft state into a Sent state.
To mark a Sent invoice as Paid you have two choices. You can manually do this by clicking on the green arrows (>>) pointing from Sent to Paid. You will then be asked to manually add a bank account entry and select an invoice to allocate the money to. Alternatively, if you are uploading your bank account statements, just click on the unexplained transaction which relates to the invoice payment, select Invoice Receipt as the transaction type and then select the invoice to allocate the money to.
However, given the Paypal scenario you describe, you might want to take a different approach -- one we use for FreeAgent Central's accounts in fact.
You should first add a new Bank Account to FreeAgent which represents your Paypal account (you'll have to make up a sort code and account number for now -- we don't explicitly model Paypal accounts just yet).
Next, from the Paypal website you can download all your transaction data in CSV format (they say they support QIF, although we're finding that it isn't actually available at present) and then upload this statement into your newly created FreeAgent Paypal Bank Account. This would allow you to explain the actual Paypal transactions against the invoices and then explain the transfers between Paypal and your Bank Account as transfers in FreeAgent.
One caveat. At present we only import the NET amount from the Paypal CSV file, not the GROSS amount, which would still leave you with a disparity between the transaction amount and the invoice amount. However, we can make a change for next week's FreeAgent release so that both the gross transaction and the Paypal fee are listed as separate transactions. This would allow you to fully model all the money in and out of both Paypal and your bank account.
Would this be a viable solution for you?
The company says
this answers the question
-
Inappropriate?Thanks for your super fast response!
I didn't see the arrows were clickable. They were grey; the colour of "disabled" so I didn't even think to hover my mouse over them.
Marking the invoice as paid worked well though - however, it oddly made an entry in my bank account statement (!!). This isn't desired, since I wish to download the .qif statements from my bank (which I have been doing and this works very well).
I can see that now I have a paid invoice I'm able to explain it in the bank statement. I couldn't see the explain option before (presumably hidden as I had no invoices needing explanation). In this particular example, I still have £14.14 showing "unpaid" for this invoice. I can see a "write off unpaid" button - which would be incorrect for my accounts. The best thing here for me would be a "attribute unpaid to cost of sale" button. That would be very useful.
We also receive money from Google Checkout in addition to PayPal, so I'd prefer not to have to set up accounts for every possible revenue stream that uses one. However, if you can create the gross and net figures as importable from PayPal that would be of a tremendous help - and would certainly go a long way to getting FreeAgent into the Micro-ISV community!
Many thanks,
Mike
I’m confident
-
Inappropriate?If you're uploading bank statements then rather than manually marking the invoice as paid, you should explain the unexplained bank transaction as an Invoice Receipt.
If the unexplained transaction amount was the same as the invoice total then the invoice would automatically be marked as Paid. In your case, since the transaction amount is LESS than the invoice total (due to the Paypal fee), then the invoice remains in a Sent state. However at this stage you can simply click the WRITE-OFF UNPAID button which will do exactly what you want!
This is certainly a valid workaround for your situation, but using a separate Paypal account would provide a fully accurate model of your finances. It shouldn't take up much more of your time than your current process -- it's really simple. In fact, it may even save you time because FreeAgent gradually learns more about your explanations and will start to automatically explain them for you (where possible) when you upload your statements.
We'll look into supporting Google Checkout. Are there any other payment mechanisms you use in addition to these two?
The company says
this answers the question
-
Inappropriate?Olly,
Thanks for your near-instaneous response.
I'm a bit nervous about the "Write-Off Unpaid" button, since the difference in this case (due to the PayPal fee) is actually a cost of sale and needs to be accounted as such to keep the P&L correct.
However, the additional account option I think is our way forward. As long as you can import the gross figure from PayPal, I assume I can specify the PayPal account as "payment" for the invoice (or it will be detected automatically as the figures will be the same for the invoice and the payment).
Using PayPal in this way, I should be able to account for the fee as a "Bank/Finance Charge".
With Google Checkout, it's going to be more complex. We are dropping PayPal as an advertised payment mechanism and are migrating to Google Checkout (it has lower fees). But there might not be a way to account for the fees coming in from a Google Checkout purchase since I'm not sure if Google report this as a seperate line on an exportable statement. They might do, I think we should both check :)
Worldpay are another popular payment processor that many people (including freelancers billing for retainers) use that you should consider.
Thanks very much for your help.
Warm Regards,
Mike Wilson
I’m confident
-
Inappropriate?Hi Mike,
We'll aim to get the changes to Paypal accounts ready for the next release, scheduled for next Monday.
Once you import the Paypal statement into FreeAgent, you will see each unexplained transaction. Just click on one to explain a transaction as an Invoice Receipt. The invoice in question (assuming the amounts are indeed the same) will then automatically be marked as Paid.
Regarding Google Checkout, we don't (yet) have an account but it seems they do allow all the order data to be exported using the 'Download data to spreadsheet (.csv)' option. Would you be able to check to see if this contains Gross, Net and Fee information as the Paypal statements do?
Thanks for the heads-up on World Pay.
The company says
this answers the question
-
Inappropriate?Hi Olly,
We're currently moving to Google Checkout, and have yet to process our first transaction through it. However the headers on the report show Total, and Chrg. So that's the gross and fee done, I think the net might need to be calculated from that. Sorry I couldn't help more on Google Checkout :(
Warm Regards,
Mike Wilson
I’m confident
-
Inappropriate?Just to wrap this one up:
It's entirely possible right now to handle this correctly.
Transactions uploaded from Paypal represent the net amount you receive. If you explain them as Invoice Receipts, but edit the explanation value to match the full value of the invoice (which will be larger than the transaction value, but ignore this for now), the invoice will be fully marked as paid (no need to write anything off) but the transaction will still be unexplained to the tune of the difference.
You can then explain this (payment) difference as Bank/Finance Charges and the accounts are hunky-dory.
If we change FreeAgent so each payment is represented as two transactions (1 receipt, 1 fee) then these two would just be explained separately. The fees would be auto-explained once you'd done it once, and the invoice receipt will be auto-explained in the future as long as it matches the value of an unpaid invoice.
That's why we're going to make this change for next week - just to streamline things. With that work, we're ironing out some issues with repeated uploads, since it's harder to detect duplicates, but we don't see any showstoppers.
Does that about cover it?
1 person says
this answers the question
-
Inappropriate?Yup, that's perfect. A walkthrough for the exporting from Paypal / importing into FreeAgent would be useful. My Paypal export files are either empty (yes, I checked the account and date ranges) or contain data in an .iif file format that FreeAgent can't read.
Work on the documentation is someting to bear in mind for the next release :)
Warm Regards,
Mike Wilson
I’m happy
-
Inappropriate?Here's how to export your Paypal data and import it into FreeAgent.
Paypal:
1. Log into your account at www.paypal.com
2. Click on the My Account tab if it isn't already selected
3. Select Download History from the drop-down menu displayed by hovering the mouse over the History sub nav option
4. Select either Custom Date Range or Last Download To Present, depending upon which you want
5. Select "Comma Delimited - Balance Affecting Payments" from the File Type drop down list
6. Click the Download History button and save the CSV file to your desktop
FreeAgent:
1. Log into your FreeAgent account
2. Click the Bank Accounts navigation option
3. Click the Bank Account you'd like to upload the data to
4. Click the Upload a Statement button
5. Click Browse and select the file from your desktop
6. Click upload
Voila!
I’m hoping this helps
Loading Profile...



EMPLOYEE
