Bank Reconciliation 1

[muhaidib]

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

 

[ettienne]

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.

 

[muhaidib]

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.

 

[Jay Converse]

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.

 

[ettienne]

OFX converter:

http://www.xs4all.nl/~csmale/mt2ofx/en/