Automatic bank reconciliation

I am looking for a cloud based accounting system to integrate into an IT
system currently in development. I have a specific requirement whereby I
need to be able to programmatically reconcile bank transactions to sales
invoices.

My system is based on monthly subscriptions, and sales invoices will only
be created if they have successfully been paid through Paypal / Amazon.
Each successful payment will have a unique id attached to it to feed
through to the bank transaction as well as the sales invoice. The sales
invoice will then be sent through to the accounting platform.

At a future date I want my platform to log in and reconcile these sales
invoices against bank transactions using the unique transaction id. Can
this be done via the freeagent API? I want to minimise human involvement as
much as possible.

Thanks

Liam

Forgot to add a link for the explanation
API: https://dev.freeagent.com/docs/bank_transaction_explanations#create-a-bank-transaction-explanationOn Friday, September 25, 2015 at 2:57:42 PM UTC+1, Ioan Serban wrote:

Hi Liam,

I think this should be possible via our API. You can send these sales
invoices to FreeAgent via our API, then at a later date create a
transaction explanation with paid_invoice attribute set to the correct
value, based on code you write to match the invoice and transactions to the
reference. You could even set up a PayPal feed for the bank account,
which can pull in your transactions automatically.

Let me know if there’s anything else I can help with.

Cheers,
Ioan

On Monday, September 21, 2015 at 2:54:56 PM UTC+1, Liam Flavelle wrote:

I am looking for a cloud based accounting system to integrate into an IT
system currently in development. I have a specific requirement whereby I
need to be able to programmatically reconcile bank transactions to sales
invoices.

My system is based on monthly subscriptions, and sales invoices will only
be created if they have successfully been paid through Paypal / Amazon.
Each successful payment will have a unique id attached to it to feed
through to the bank transaction as well as the sales invoice. The sales
invoice will then be sent through to the accounting platform.

At a future date I want my platform to log in and reconcile these sales
invoices against bank transactions using the unique transaction id. Can
this be done via the freeagent API? I want to minimise human involvement as
much as possible.

Thanks

Liam

This is great information - thank you.

Can I please confirm that we can reconcile against one payment against
multiple invoices? split reconciliation if you will.

Thanks
TimOn Friday, 25 September 2015 14:58:16 UTC+1, Ioan Serban wrote:

Forgot to add a link for the explanation API:
https://dev.freeagent.com/docs/bank_transaction_explanations#create-a-bank-transaction-explanation

On Friday, September 25, 2015 at 2:57:42 PM UTC+1, Ioan Serban wrote:

Hi Liam,

I think this should be possible via our API. You can send these sales
invoices to FreeAgent via our API, then at a later date create a
transaction explanation with paid_invoice attribute set to the correct
value, based on code you write to match the invoice and transactions to the
reference. You could even set up a PayPal feed for the bank account,
which can pull in your transactions automatically.

Let me know if there’s anything else I can help with.

Cheers,
Ioan

On Monday, September 21, 2015 at 2:54:56 PM UTC+1, Liam Flavelle wrote:

I am looking for a cloud based accounting system to integrate into an IT
system currently in development. I have a specific requirement whereby I
need to be able to programmatically reconcile bank transactions to sales
invoices.

My system is based on monthly subscriptions, and sales invoices will
only be created if they have successfully been paid through Paypal /
Amazon. Each successful payment will have a unique id attached to it to
feed through to the bank transaction as well as the sales invoice. The
sales invoice will then be sent through to the accounting platform.

At a future date I want my platform to log in and reconcile these sales
invoices against bank transactions using the unique transaction id. Can
this be done via the freeagent API? I want to minimise human involvement as
much as possible.

Thanks

Liam

Hi Tim,

Absolutely, you can apply several explanations against the same bank
transaction.
All you need to do is pass through the same bank_transaction ID as a
parameter and different values for *paid_invoice *and gross_value.
This will create multiple invoice receipts against the same entry in the
bank.

I hope this helps!
Dave JOn 21 April 2016 at 08:59, Tim Dixon tim@tjdixon.com wrote:

This is great information - thank you.

Can I please confirm that we can reconcile against one payment against
multiple invoices? split reconciliation if you will.

Thanks
Tim

On Friday, 25 September 2015 14:58:16 UTC+1, Ioan Serban wrote:

Forgot to add a link for the explanation API:
https://dev.freeagent.com/docs/bank_transaction_explanations#create-a-bank-transaction-explanation

On Friday, September 25, 2015 at 2:57:42 PM UTC+1, Ioan Serban wrote:

Hi Liam,

I think this should be possible via our API. You can send these sales
invoices to FreeAgent via our API, then at a later date create a
transaction explanation with paid_invoice attribute set to the correct
value, based on code you write to match the invoice and transactions to the
reference. You could even set up a PayPal feed for the bank account,
which can pull in your transactions automatically.

Let me know if there’s anything else I can help with.

Cheers,
Ioan

On Monday, September 21, 2015 at 2:54:56 PM UTC+1, Liam Flavelle wrote:

I am looking for a cloud based accounting system to integrate into an
IT system currently in development. I have a specific requirement whereby I
need to be able to programmatically reconcile bank transactions to sales
invoices.

My system is based on monthly subscriptions, and sales invoices will
only be created if they have successfully been paid through Paypal /
Amazon. Each successful payment will have a unique id attached to it to
feed through to the bank transaction as well as the sales invoice. The
sales invoice will then be sent through to the accounting platform.

At a future date I want my platform to log in and reconcile these sales
invoices against bank transactions using the unique transaction id. Can
this be done via the freeagent API? I want to minimise human involvement as
much as possible.

Thanks

Liam


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 https://groups.google.com/group/freeagent_api.

For more options, visit https://groups.google.com/d/optout.

David Jones
Support Engineering Team Lead

FreeAgent

Hi Liam,

I think this should be possible via our API. You can send these sales
invoices to FreeAgent via our API, then at a later date create a
transaction explanation with paid_invoice attribute set to the correct
value, based on code you write to match the invoice and transactions to the
reference. You could even set up a PayPal feed for the bank account, which
can pull in your transactions automatically.

Let me know if there’s anything else I can help with.

Cheers,
IoanOn Monday, September 21, 2015 at 2:54:56 PM UTC+1, Liam Flavelle wrote:

I am looking for a cloud based accounting system to integrate into an IT
system currently in development. I have a specific requirement whereby I
need to be able to programmatically reconcile bank transactions to sales
invoices.

My system is based on monthly subscriptions, and sales invoices will only
be created if they have successfully been paid through Paypal / Amazon.
Each successful payment will have a unique id attached to it to feed
through to the bank transaction as well as the sales invoice. The sales
invoice will then be sent through to the accounting platform.

At a future date I want my platform to log in and reconcile these sales
invoices against bank transactions using the unique transaction id. Can
this be done via the freeagent API? I want to minimise human involvement as
much as possible.

Thanks

Liam