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?
Thanks,
Matt
Hello Matt!
When pulling the bank_transaction_explanations
or 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,
Florent
Hi Florent,
Thanks very much for your reply.
Here’s an example accounting entry which could be pulled from bank_transaction_explanations
:
Dr Bank 10
Cr Sales 10
The 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.
Matt
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
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)?
Thanks,
Matt
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)
Florent