Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bank Reconciliation 1

Status
Not open for further replies.

muhaidib

Programmer
Sep 27, 2005
82
SA
Using ACCPAC 5.5A with all upgrades MSSQL database.

I want to use bank reconciliation from Bank module.
1. Before starting to work on data Jan09 onwards I want to mark all the data before 01Jan09 as reconciled. How to do that?

2. Secondly withdrawal tab is not showing any data for some of the banks. I found that the table BKCHK has no entries for these banks. Is it case of some wrong inputs or set up?

3. Can I import bank statement in .csv or .xls format and
do matching on the basis of reference, date and amount of transaction

 
Read the Tax and Bank Guide manual.
1. Bank Services, Bank Transactions, Reconcile Statements.
2. No checks have been entered for the bank.
3. No, you have to import OFX files.
 
Thanks for reply.

I did reconciled all the transaction before Jan09. But those are visible. I want to see transactions Jan09 onwards.

Secondly is there .txt/.csv to .ofx converter available? as all the banks gives either .csv/ .txt or .xls format.
 
To see later transactions, you need to post the current reconciliation and change the reconciliation date to a later date.

To find an OFX converter, use Google, there are good free ones out there.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top