Best practice startup for US-style importing OFX files for Bank Account and Credit Card account

Support User
1

Greetings, [LONG MESSAGE]…I’m just starting out experimenting with Tryton, and have become a bit confused in the terminology/use for certain modules, specifically “accounts”, “statements” and “journals” - these seem to be applied differently than my understanding for US-style accounting terms, and specifically versus other locally-popular accounting packages such as Sage, Quickbooks and SAP.

I would like some advice in what process and order of operations I should perform in the (account->bank->journal->statement import … ?) to perform the following:

  1. Given two “bank accounts”, one a checking/operating account and the other a credit card, I am able to provide OFX files from my bank to be imported.
  2. The “checking account” will have deposits and withdrawals, the deposits would need to be processed as payments from customers and the withdrawals would need to be processed as vendor outbound payments. (I only state this, although obvious, because some other accounting platforms don’t actually let you do this!)
  3. The credit card would have lots of charges, which would need to be associated with certain accounts on the Chart of Accounts, such as “Office Supplies”, “Internet Expenses”, “Shipping Costs”, etc.
  4. There would also be transactions that are credit card payments, typically from the above bank account, which would need to be associated. In this particular case, the “checking account” would have one withdrawal/debit and the credit card would have one payment/credit of same value to be matched.

Again, I am just starting out with Tryton and am still going through documentation, but the demo looked really good to me. I did put together a “Sample” ofx file from my own institution (redacted all the private data) and was able to upload the file to the demo site, but the response I got was “To Import Statements, you must create a journal for account 56785678”.
In the ofx file, the bank details are as follows:

12341234
56785678
CHECKING

So it does appear to trigger on the tag. (Which is good).
I then created a journal, but clearly did not do it correctly, as further attempts to import did not succeed.

Apologies for the long post, but I am really interested in using this package, so certainly don’t want to misconfigure based upon a different assumed process (like Quickbooks).

Kindest regards,
Ted.

2

Hi,

First of all you must created a statement journal for each account you will like to import the transactions. When importing a file tryton will try to automatically detect the journal by using its related bank account number. The error message you are getting is because you did not have the journals created or they are not linked to any account, so the system is unable to find them.

Once you fix that the import wizard will create a new statement which has all the origins filed. The origin is a 1 to 1 relation to any move you have on the file. For each origin you must create one (or more) moves to decide on which account you will like to book the move. From there you can link it to invoices or just set directly the accounts.

After you’ve filled all the lines of the statement you will be able to validate and post the moves. So all your statement moves are booked in your accounting records.

Hope this helps!