FrontAccounting forum — importing bank data

Re: importing bank data

null@example.com (oldfunguy) — Sun, 22 Mar 2020 21:50:44 +0000

New to front accounting, I activated the import tranactions in set up and now the item shows up in the menu, but when you click it there is nothing there. Am I missing something? is there more to it than what I've done?
any help would be appreciated

Re: importing bank data

null@example.com (Rdugert) — Wed, 04 Mar 2020 16:03:06 +0000

Raddison thanks for this nice plugin, an essential one actually.
Regarding Bank Statements, the only time consuming thing about the process is to have csv's broken in 2 parts, for deposits and payments.
Would be cool if we had a way to import bank statements in one shot.
It this doable?
Tx!

Re: importing bank data

null@example.com (raddison) — Mon, 16 Mar 2015 11:54:09 +0000

You can now import bank statements in csv format using the Import Transactions extension.

Using the extension:
1. Download Bank statement from your bank in csv format.
2. Add additional columns to this csv for reference, (coa) account numbers, vat code (if transaction includes vat/gst), using the provided template, and supplier or customer ids.
3. 'Trial run' on this adusted csv to validate existence of account codes, and supplier/customer ids.
4. If successful Trial run then uncheck 'trial run' checkbox and import the adjusted csv.

Now Using Front Accounting:
Allocate imported customer receipts (Sales...Allocate customer payments) and supplier payments (Purchases....Allocate supplier payments) against appropriate invoices.

So before the csv can be imported, correct account code matching, vat code matching, and supplier/customer matching must be
made to each line of the bank statement in csv format.

Re: importing bank data

null@example.com (staple) — Wed, 22 Dec 2010 04:25:10 +0000

This would be a very useful feature - it is the feature that is the 'killer app' of many of the hosted accounting solutions (Xero etc) - a great time saver.

I agree with hugojacobs - just have a standard csv format to start with as people can massage their statements into it.

Re: importing bank data

null@example.com (itronics) — Sat, 22 May 2010 12:56:44 +0000

No, this is not implemented so far.
Janusz

Re: importing bank data

null@example.com (hugojacobs) — Sat, 22 May 2010 11:17:22 +0000

Hello,

The last contribution to this item is 2 years ago, I am curious if there has been a follow-up on this. For me it would be very usefull to have a function like this. I think it would be ok to have one input format, every user can transform his file into this format.

Thanks for your help!

Re: importing bank data

null@example.com (alvin) — Wed, 21 May 2008 21:30:51 +0000

I also would like an import feature, Bank of America offers your file as csv, and more. maybe other banks do as well. Many transactions are done at the bank level, bill payments, and transfers, all done online. Once a month you just import instead of entering them.

csv should be pretty straight froward.

Re: importing bank data

null@example.com (openkiwi) — Mon, 28 Apr 2008 07:48:51 +0000

Yes, saves a lota time, thats exactly what I mean Glennr!

Re: importing bank data

null@example.com (joe) — Sun, 27 Apr 2008 10:28:59 +0000

Thanks glennr,
Yes I think this will be a very good candidate for an add-on module. Unfortunately I'm not very qood at the .qif format. Maybe someone out there will look at it and write an add-on module for this. It would be straight forward if you know the format of the .qif file.

/Joe

Re: importing bank data

null@example.com (glennr) — Sat, 26 Apr 2008 23:19:43 +0000

I'm not sure what the original poster wanted this but what I use this feature for, in MYOB, is to import a bank statement in .qif format. MYOB tries to match transactions with already entered transactions and offers an interface to add the unmatched transactions. If you just want to categorize all the transactions from your bank statement(s) then this is very useful and saves a lot of time.

Re: importing bank data

null@example.com (joe) — Sat, 26 Apr 2008 07:55:25 +0000

I am not sure if I understand the purpose of this. Is this for reconciliation or do you mean payments from customers?

/Joe

importing bank data

null@example.com (openkiwi) — Sat, 26 Apr 2008 01:19:32 +0000

I would like to be able to import .qif , ofx, csv or ofc, possible?