Hi all,
Im trying to follow this
guide, http://www.freeagent.com/support/kb/banking/split-a-transaction-for-commission-or-charges-deducted
and achieve the same in the API.
I’ll explain a little bit of how our payments etc work, we’re a UK based
company.
- We invoice a US customer for say $100 (creating an Invoice in
Freeagent).
- The customer pays in our system using Stripe.
- Stripe converts $100 in to GBP and also takes a fee (e.g. £5).
- We import our bank statements and we get a £65 transaction (for
arguments sake, not actual figures). Obviously this amount is USD converted
into GBP minus Stripe’s fee (for arguments sake £5)
What I want to be able to is programmatically “Explain” these transactions.
I can create a bank_transaction_explanation through the API with the
paid_invoice linking to the correct one, with a gross value of £70 and
a foreign_currency_value of 100. This obviously marks the invoice as paid
and adds an explanation to a transaction. But this also leaves a -£5
unexplained transaction.
If I try and add another explanation it says the invoice has already been
paid. So I tried creating two explanations, one with
a foreign_currency_value of 99 and the stripe charges with a gross_value of
£5 and a foreign_currency_value 1 (which should both pay the invoice), but
the second stripe charges transactions always appears as “Money In”, when
it actually needs to be “Money Out”, despite setting it to a minus and with
a category of 363 which is Bank charges.
I hope that all makes sense! If Im not doing it correctly can you let me
know how I should do it?
Hi David,
That does help yes 
We don’t actually have a separate £5 transaction. From reading the guide
above we need to account for the Stripe charges. So essentially we get £65
on out bank statement. Thats actually £70 minus £5 of stripe charges, so it
appears as £65 on the bank statement.
It might be worth looking at bank account 1306 and bank_transaction_id
5663. You should be able to see that I have created a money in bank
explanation of £70 and Freeagent has flagged as £5 an unexplained. I can
create a money out explanation through the front end and it works as
expected, but I can’t seem to get it working using the API.
Hope that makes sense 
AdamOn Monday, 12 January 2015 13:32:23 UTC, David Jones wrote:
Hi Adam,
I think you’re almost there.
So, you add the first invoice receipt which full pays off the outstanding
invoice and automatically creates a balancing £5 Money Out transaction.
At this point, the £5 Money Out is sat in your account as an unexplained
bank transaction. I think you just need to create a second bank
explanation, passing the ID of the £5 transaction, and explain it to
Bank/Finance charges (or whatever seems applicable to you).
Does that help?
On 12 January 2015 at 13:19, Adam Curtis <ad...@mooloop.com <javascript:>> wrote:
Hi all,
Im trying to follow this guide,
http://www.freeagent.com/support/kb/banking/split-a-transaction-for-commission-or-charges-deducted
and achieve the same in the API.
I’ll explain a little bit of how our payments etc work, we’re a UK based
company.
- We invoice a US customer for say $100 (creating an Invoice in
Freeagent).
- The customer pays in our system using Stripe.
- Stripe converts $100 in to GBP and also takes a fee (e.g. £5).
- We import our bank statements and we get a £65 transaction (for
arguments sake, not actual figures). Obviously this amount is USD converted
into GBP minus Stripe’s fee (for arguments sake £5)
What I want to be able to is programmatically “Explain” these
transactions.
I can create a bank_transaction_explanation through the API with the
paid_invoice linking to the correct one, with a gross value of £70 and
a foreign_currency_value of 100. This obviously marks the invoice as paid
and adds an explanation to a transaction. But this also leaves a -£5
unexplained transaction.
If I try and add another explanation it says the invoice has already been
paid. So I tried creating two explanations, one with
a foreign_currency_value of 99 and the stripe charges with a gross_value of
£5 and a foreign_currency_value 1 (which should both pay the invoice), but
the second stripe charges transactions always appears as “Money In”, when
it actually needs to be “Money Out”, despite setting it to a minus and with
a category of 363 which is Bank charges.
I hope that all makes sense! If Im not doing it correctly can you let me
know how I should do it?
–
You received this message because you are subscribed to the Google Groups
“FreeAgent API” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to freeagent_ap...@googlegroups.com <javascript:>.
To post to this group, send email to freeag...@googlegroups.com
<javascript:>.
Visit this group at http://groups.google.com/group/freeagent_api.
For more options, visit https://groups.google.com/d/optout.
–
David Jones
Senior Support Engineer
FreeAgent
No problem, Adam, glad you got it sorted!On 12 January 2015 at 14:43, Adam Curtis adam@mooloop.com wrote:
Hi David,
Sorry, ignore all of the above, I managed to figure it out!
Thanks for your help by the way, excellent support
Adam
On Monday, 12 January 2015 14:40:46 UTC, Adam Curtis wrote:
I also noticed that the bank_transaction_explantion description is also
ignored when creating the explanation, it just gets set to “Invoice receipt
against 001” regardless of whats passed.
Adam
On Monday, 12 January 2015 14:35:53 UTC, Adam Curtis wrote:
Hi David,
That does help yes
We don’t actually have a separate £5 transaction. From reading the guide
above we need to account for the Stripe charges. So essentially we get £65
on out bank statement. Thats actually £70 minus £5 of stripe charges, so it
appears as £65 on the bank statement.
It might be worth looking at bank account 1306 and bank_transaction_id
5663. You should be able to see that I have created a money in bank
explanation of £70 and Freeagent has flagged as £5 an unexplained. I can
create a money out explanation through the front end and it works as
expected, but I can’t seem to get it working using the API.
Hope that makes sense
Adam
On Monday, 12 January 2015 13:32:23 UTC, David Jones wrote:
Hi Adam,
I think you’re almost there.
So, you add the first invoice receipt which full pays off the
outstanding invoice and automatically creates a balancing £5 Money Out
transaction.
At this point, the £5 Money Out is sat in your account as an
unexplained bank transaction. I think you just need to create a second bank
explanation, passing the ID of the £5 transaction, and explain it to
Bank/Finance charges (or whatever seems applicable to you).
Does that help?
On 12 January 2015 at 13:19, Adam Curtis ad...@mooloop.com wrote:
Hi all,
Im trying to follow this guide, http://www.freeagent.
com/support/kb/banking/split-a-transaction-for-commission-
or-charges-deducted and achieve the same in the API.
I’ll explain a little bit of how our payments etc work, we’re a UK
based company.
- We invoice a US customer for say $100 (creating an Invoice in
Freeagent).
- The customer pays in our system using Stripe.
- Stripe converts $100 in to GBP and also takes a fee (e.g. £5).
- We import our bank statements and we get a £65 transaction (for
arguments sake, not actual figures). Obviously this amount is USD converted
into GBP minus Stripe’s fee (for arguments sake £5)
What I want to be able to is programmatically “Explain” these
transactions.
I can create a bank_transaction_explanation through the API with the
paid_invoice linking to the correct one, with a gross value of £70 and
a foreign_currency_value of 100. This obviously marks the invoice as paid
and adds an explanation to a transaction. But this also leaves a -£5
unexplained transaction.
If I try and add another explanation it says the invoice has already
been paid. So I tried creating two explanations, one with
a foreign_currency_value of 99 and the stripe charges with a gross_value of
£5 and a foreign_currency_value 1 (which should both pay the invoice), but
the second stripe charges transactions always appears as “Money In”, when
it actually needs to be “Money Out”, despite setting it to a minus and with
a category of 363 which is Bank charges.
I hope that all makes sense! If Im not doing it correctly can you let
me know how I should do it?
–
You received this message because you are subscribed to the Google
Groups “FreeAgent API” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to freeagent_ap...@googlegroups.com.
To post to this group, send email to freeag...@googlegroups.com.
Visit this group at http://groups.google.com/group/freeagent_api.
For more options, visit https://groups.google.com/d/optout.
–
David Jones
Senior Support Engineer
FreeAgent
–
You received this message because you are subscribed to the Google Groups
“FreeAgent API” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to freeagent_api+unsubscribe@googlegroups.com.
To post to this group, send email to freeagent_api@googlegroups.com.
Visit this group at http://groups.google.com/group/freeagent_api.
For more options, visit https://groups.google.com/d/optout.
David Jones
Senior Support Engineer
FreeAgent
I also noticed that the bank_transaction_explantion description is also
ignored when creating the explanation, it just gets set to “Invoice receipt
against 001” regardless of whats passed.
AdamOn Monday, 12 January 2015 14:35:53 UTC, Adam Curtis wrote:
Hi David,
That does help yes
We don’t actually have a separate £5 transaction. From reading the guide
above we need to account for the Stripe charges. So essentially we get £65
on out bank statement. Thats actually £70 minus £5 of stripe charges, so it
appears as £65 on the bank statement.
It might be worth looking at bank account 1306 and bank_transaction_id
5663. You should be able to see that I have created a money in bank
explanation of £70 and Freeagent has flagged as £5 an unexplained. I can
create a money out explanation through the front end and it works as
expected, but I can’t seem to get it working using the API.
Hope that makes sense
Adam
On Monday, 12 January 2015 13:32:23 UTC, David Jones wrote:
Hi Adam,
I think you’re almost there.
So, you add the first invoice receipt which full pays off the outstanding
invoice and automatically creates a balancing £5 Money Out transaction.
At this point, the £5 Money Out is sat in your account as an unexplained
bank transaction. I think you just need to create a second bank
explanation, passing the ID of the £5 transaction, and explain it to
Bank/Finance charges (or whatever seems applicable to you).
Does that help?
On 12 January 2015 at 13:19, Adam Curtis ad...@mooloop.com wrote:
Hi all,
Im trying to follow this guide,
http://www.freeagent.com/support/kb/banking/split-a-transaction-for-commission-or-charges-deducted
and achieve the same in the API.
I’ll explain a little bit of how our payments etc work, we’re a UK based
company.
- We invoice a US customer for say $100 (creating an Invoice in
Freeagent).
- The customer pays in our system using Stripe.
- Stripe converts $100 in to GBP and also takes a fee (e.g. £5).
- We import our bank statements and we get a £65 transaction (for
arguments sake, not actual figures). Obviously this amount is USD converted
into GBP minus Stripe’s fee (for arguments sake £5)
What I want to be able to is programmatically “Explain” these
transactions.
I can create a bank_transaction_explanation through the API with the
paid_invoice linking to the correct one, with a gross value of £70 and
a foreign_currency_value of 100. This obviously marks the invoice as paid
and adds an explanation to a transaction. But this also leaves a -£5
unexplained transaction.
If I try and add another explanation it says the invoice has already
been paid. So I tried creating two explanations, one with
a foreign_currency_value of 99 and the stripe charges with a gross_value of
£5 and a foreign_currency_value 1 (which should both pay the invoice), but
the second stripe charges transactions always appears as “Money In”, when
it actually needs to be “Money Out”, despite setting it to a minus and with
a category of 363 which is Bank charges.
I hope that all makes sense! If Im not doing it correctly can you let me
know how I should do it?
–
You received this message because you are subscribed to the Google
Groups “FreeAgent API” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to freeagent_ap...@googlegroups.com.
To post to this group, send email to freeag...@googlegroups.com.
Visit this group at http://groups.google.com/group/freeagent_api.
For more options, visit https://groups.google.com/d/optout.
–
David Jones
Senior Support Engineer
FreeAgent
Hi Adam,
I think you’re almost there.
So, you add the first invoice receipt which full pays off the outstanding
invoice and automatically creates a balancing £5 Money Out transaction.
At this point, the £5 Money Out is sat in your account as an unexplained
bank transaction. I think you just need to create a second bank
explanation, passing the ID of the £5 transaction, and explain it to
Bank/Finance charges (or whatever seems applicable to you).
Does that help?On 12 January 2015 at 13:19, Adam Curtis adam@mooloop.com wrote:
Hi all,
Im trying to follow this guide,
http://www.freeagent.com/support/kb/banking/split-a-transaction-for-commission-or-charges-deducted
and achieve the same in the API.
I’ll explain a little bit of how our payments etc work, we’re a UK based
company.
- We invoice a US customer for say $100 (creating an Invoice in
Freeagent).
- The customer pays in our system using Stripe.
- Stripe converts $100 in to GBP and also takes a fee (e.g. £5).
- We import our bank statements and we get a £65 transaction (for
arguments sake, not actual figures). Obviously this amount is USD converted
into GBP minus Stripe’s fee (for arguments sake £5)
What I want to be able to is programmatically “Explain” these
transactions.
I can create a bank_transaction_explanation through the API with the
paid_invoice linking to the correct one, with a gross value of £70 and
a foreign_currency_value of 100. This obviously marks the invoice as paid
and adds an explanation to a transaction. But this also leaves a -£5
unexplained transaction.
If I try and add another explanation it says the invoice has already been
paid. So I tried creating two explanations, one with
a foreign_currency_value of 99 and the stripe charges with a gross_value of
£5 and a foreign_currency_value 1 (which should both pay the invoice), but
the second stripe charges transactions always appears as “Money In”, when
it actually needs to be “Money Out”, despite setting it to a minus and with
a category of 363 which is Bank charges.
I hope that all makes sense! If Im not doing it correctly can you let me
know how I should do it?
–
You received this message because you are subscribed to the Google Groups
“FreeAgent API” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to freeagent_api+unsubscribe@googlegroups.com.
To post to this group, send email to freeagent_api@googlegroups.com.
Visit this group at http://groups.google.com/group/freeagent_api.
For more options, visit https://groups.google.com/d/optout.
David Jones
Senior Support Engineer
FreeAgent
Hi David,
Sorry, ignore all of the above, I managed to figure it out!
Thanks for your help by the way, excellent support
AdamOn Monday, 12 January 2015 14:40:46 UTC, Adam Curtis wrote:
I also noticed that the bank_transaction_explantion description is also
ignored when creating the explanation, it just gets set to “Invoice receipt
against 001” regardless of whats passed.
Adam
On Monday, 12 January 2015 14:35:53 UTC, Adam Curtis wrote:
Hi David,
That does help yes
We don’t actually have a separate £5 transaction. From reading the guide
above we need to account for the Stripe charges. So essentially we get £65
on out bank statement. Thats actually £70 minus £5 of stripe charges, so it
appears as £65 on the bank statement.
It might be worth looking at bank account 1306 and bank_transaction_id
5663. You should be able to see that I have created a money in bank
explanation of £70 and Freeagent has flagged as £5 an unexplained. I can
create a money out explanation through the front end and it works as
expected, but I can’t seem to get it working using the API.
Hope that makes sense
Adam
On Monday, 12 January 2015 13:32:23 UTC, David Jones wrote:
Hi Adam,
I think you’re almost there.
So, you add the first invoice receipt which full pays off the
outstanding invoice and automatically creates a balancing £5 Money Out
transaction.
At this point, the £5 Money Out is sat in your account as an unexplained
bank transaction. I think you just need to create a second bank
explanation, passing the ID of the £5 transaction, and explain it to
Bank/Finance charges (or whatever seems applicable to you).
Does that help?
On 12 January 2015 at 13:19, Adam Curtis ad...@mooloop.com wrote:
Hi all,
Im trying to follow this guide,
http://www.freeagent.com/support/kb/banking/split-a-transaction-for-commission-or-charges-deducted
and achieve the same in the API.
I’ll explain a little bit of how our payments etc work, we’re a UK
based company.
- We invoice a US customer for say $100 (creating an Invoice in
Freeagent).
- The customer pays in our system using Stripe.
- Stripe converts $100 in to GBP and also takes a fee (e.g. £5).
- We import our bank statements and we get a £65 transaction (for
arguments sake, not actual figures). Obviously this amount is USD converted
into GBP minus Stripe’s fee (for arguments sake £5)
What I want to be able to is programmatically “Explain” these
transactions.
I can create a bank_transaction_explanation through the API with the
paid_invoice linking to the correct one, with a gross value of £70 and
a foreign_currency_value of 100. This obviously marks the invoice as paid
and adds an explanation to a transaction. But this also leaves a -£5
unexplained transaction.
If I try and add another explanation it says the invoice has already
been paid. So I tried creating two explanations, one with
a foreign_currency_value of 99 and the stripe charges with a gross_value of
£5 and a foreign_currency_value 1 (which should both pay the invoice), but
the second stripe charges transactions always appears as “Money In”, when
it actually needs to be “Money Out”, despite setting it to a minus and with
a category of 363 which is Bank charges.
I hope that all makes sense! If Im not doing it correctly can you let
me know how I should do it?
–
You received this message because you are subscribed to the Google
Groups “FreeAgent API” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to freeagent_ap...@googlegroups.com.
To post to this group, send email to freeag...@googlegroups.com.
Visit this group at http://groups.google.com/group/freeagent_api.
For more options, visit https://groups.google.com/d/optout.
–
David Jones
Senior Support Engineer
FreeAgent