Currently, when pulling Bank Transaction Explanations, the
bank_account field indicates which bank account is associated with the BTE.
However, when pulling Bank Accounts, there is no
category field to indicate the accounting category of the bank account. This means that we currently have no way of knowing the accounting impact of a Bank Transaction Explanation.
Are there any plans to support this?
When pulling the
bank_transactions (contains the former) from the API, you should receive for each explanation a
category which contains the url of the accounting category (see FreeAgent Developer Dashboard)
This can be queried to get more information about the category (FreeAgent Developer Dashboard)
I am not entirely sure if that answers your question so let me know
Thanks very much for your reply.
Here’s an example accounting entry which could be pulled from
Dr Bank 10
Cr Sales 10
category field only tells me the accounting category of the “Sales” account; it doesn’t tell me the accounting category of the “Bank” account. There’s no way for me to know which nominal account (category) is associated with the bank account which was impacted by the transaction, so I’ve effectively only got one half of the journal entry.
bank_transaction_explanations does have a
bank_account field, but as mentioned, there doesn’t seem to be any way I can link this to an accounting category via FreeAgent’s API.
Thanks for your help, and I look forward to hearing from you.
Right, sorry about the misunderstanding
It is indeed not supported. There is a convoluted way to get that information currently : the list all categories endpoint with
sub_account=true (FreeAgent Developer Dashboard) will return all the bank accounts with their nominal code.
The bank account nominal code should be in order of their creation 750-X with X iterating from 1
Thanks Florent, much appreciated!
I think this should work for what we’re trying to accomplish, although presumably it only works since FreeAgent enforces the uniqueness of bank account names (since that’s the only field we can search on)?
No worries, sorry to not have a more satisfactory solution for now.
The name will indeed be unique. The order of X (in 750-X) will also have the same order as the bank account ids if that helps (since they are both in order of bank account creation)