Need help with an Access bank reconciliation.

[Frank Martin]

I want to track each bank transaction from
the bank statements I receive.

Is there any standard procedure for this,
given that if I present a figure from the
bank statement to Access I can trace back (or
reconcile) the equivalent transactions in
Access?

In my application there are the following
relevant tables:

LedgerTxns
CreditorTxns
DebtorTxns
CreditorPayments
DebtorPayments
Purchases
Sales
etc.

Please help, Frank

 

[John Vinson]

Is there any standard procedure for this,

Almost any Access developer you ask will say "Buy Quicken, or
Microsoft Money, or a program written for this purpose".

Such programs have years of effort put into tuning the user interface
and features. Duplicating their functionality in Access would be a
tremendous amount of work for a piddling savings.

John W. Vinson[MVP]

 

[Frank Martin]

I can see this but all the off-the-shelf
accounting packages are just that, and they
have no Bill of Materials and are all very
deficient in Invoice formatting and other
stationary.

But then, is it possible to "tack on" one of
these accounting packages?

Regards, Frank

"John Vinson"
message

 

[TC]

Frank, table names (like DebtorTxns) mean absolutely nothing, on their
own. You need to state the Primary and Foreign Keys of each table, and
the relationships between them all. If you don't know what those terms
mean, you are not yet ready to write an accounting program in Access!

I concur with what John says. Get something off the shelf. That's what
I personally would do, if I needed an accounting program.

 

[david epsom dot com dot au]

If I really needed to modify an accounting
package, I would buy an accounting package
written in Access, with source code. They
used to and probably still advertise in Access
magazines.

Probably not as good as Quicken / Money,
but still better than spending a year trying
to do it myself.

I think you can get a BOM add-on for
Quickbooks, but it's been years since I
paid any attention.

(david)

 

[Frank Martin]

Thanks, I had my own 4-level BOM designed for
me by a consultant on a structure-only basis
and I did the rest. The trick was to get the
cascading queries right after which all was
easy.

I will try to get a similar thing done for
the accounting because my needs are fairly
simple.




"david epsom dot com dot au"