SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to index page
Thread view  Board view
arblake(R)

03.07.2016, 18:27
 

import general ledger (General)

please,

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

Adrian

Gregory West(R)

E-mail

Manitoba Canada,
12.08.2016, 02:29

@ arblake
 

import general ledger

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?
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

arblake(R)

13.08.2016, 02:25

@ Gregory West
 

import general ledger

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 West(R)

E-mail

Manitoba Canada,
13.08.2016, 10:52

@ arblake
 

import general ledger

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.


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

Gregory West(R)

E-mail

Manitoba Canada,
13.08.2016, 10:55

@ Gregory West
 

import general ledger

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

DavidJ(R)

16.08.2016, 07:51

@ arblake
 

import general ledger

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.

Not sure why you'd do that in SQL-Ledger.
How do you keep track of Sales, Purchases, Receivables, Payables from a bank statement ?
How does the statement help you decide which products/services were sold to which customer ?
How did a customer know how much to pay unless you sent a Sales Invoice ?
IMHO if you just wanna balance your checking account, then SQL-Ledger is prolly not the right tool.
SQL-L is more of an "enterprise" accounting system.
HTH

Back to index page
Thread view  Board view
973 Postings in 320 Threads, 324 registered users, 110 users online (0 registered, 110 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum