Cash Flow DB

[donsi]

Hi everyone,

This is a great forum and community here is great. Always responds to all questions. Much much appreciated all the help I have received from everyone so far.

Still a beginner here on DB and VBA.

I want to build a DB that can track the cash flow of a small cash register. Just to clarify, we are not using actual cash register. DB will be used to register people for small community events.
Cashier will have small opening bank and will do transaction throughout the day. Cashier should be able to enter money received by denomination and change given back to the customers. At the end of the day, I would like to have report generated that can give me how much money received/given in each denomination, and should show the end total of currency left in the drawer.
I created transaction table so far with each denominations but I don't know how to setup rest. Just need a little push to get started.

Thanks in advance for all the help.

 

[Ranman256]

why would you enter denominations? This will make extra work.
normally, the transaction table,
CustomeriD, Amt, EntryDate

YOUR transaction table,
customer, denom, Qty, EntryDate

 

[plog]

This seems like overkill. I've cashiered before and at the end of the shift the cared about balancing, not tracking denominations. I'd really consider if that's what you want to do.

If it is, it sounds like you have your transaction table incorreclty set up. A simple transaction is going to entail 2 tables for this:

Transactions
trans_ID, autonumber, primary key of table
trans_Time, date/time, will hold when transaction occured
...other fields...e.g. Customer, product, etc.

Denominations
den_ID, autonumber, primary key of table
den_Value, number, value of currency denomination
den_Type, text, will hold if paper or coin

Exchanges
ex_ID, autonumber, primary key
den_ID, number, link to Denominations.den_ID
trans_ID, number, link to Transactions.trans_ID
ex_Direction, text, either "To" or "From" depending if money is going to customer or coming from them
ex_Qty, number, quantity of this denomination in exchange

So, every transaction goes into Transactions and then every unique currency in the transaction gets a record in Exchanges. Also, when someone asks for 4 quarters for the vending machine, this is going to require a transaction.

Again, overkill.