SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

import general ledger (General)

posted by Gregory West(R) E-mail, Manitoba Canada, 13.08.2016, 10:55

So you are doing much like what I am doing. There is no easy way to
directly import a bank statement into SQL-Ledger, but I just use Excel and
create the import file. The import file I have in Excel look like:
reference transdate description accno debit credit

2015-10-Pay 2015-10-31 October 2015 Payroll 5750 0 2948.72
2015-10-Pay 2015-10-31 October 2015 Payroll 2450 0 11918.57
and so on....

As you can see some things the bank statement wont have are the Account
Number (accno) and any other non-bank accounts involved. Your bank
statement will show a deposit of XYZ money, what it won't show is why the
money is being deposited in the first place.

Sorry the above is missing some commas:

reference, transdate, description, accno, debit, credit,
2015-10-Pay, 2015-10-31, October 2015 Payroll, 5750, 0, 2948.72,
2015-10-Pay, 2015-10-31, October 2015 Payroll, 2450, 0, 11918.57,

Also I put in the trailing commas only because I have had import/translation issues if I didn't.


Why would you import a bank statement?

I use the GL Import quite a bit. What I use it for is to import GL
transactions from a separate program (specifically a payroll program).

What is it what you are trying to do?

I manually enter many transactions from my bank statement. A simple
import
would be easier even if I must modify the entry in the chart of
accounts.

Adrian
please,

more information as to how to use this feature. Could I use it to
import
a
bank statement?

Adrian

---
Gregory A. West
DB&W Systems Limited

 

Complete thread:

Back to the forum
Board view  Mix view
959 Postings in 314 Threads, 319 registered users, 141 users online (0 registered, 141 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum