Need help with Accounting Package I'm developing

[G37Sam]

Hello All,

So part of a DB I'm building for a Salon requires a little income & expenditure reporting.

The income from every hair service needs to be recorded, as well as daily & monthly expenses (rent, salaries etc..), some payments are made by cash others by cheque/credit card.

My question is how would you proceed in recording these transactions while keeping track of running balances?

What I'm currently doing is:

- A table to record account balances (cash, bank).
- A table to record the transactions, with every transaction the amount is added or deducted from its respective account (be it cash or bank)

With a little SQL on the transactions table I can output the needed statement of accounts.

Am I doing this right? I'd sincerely appreciate not turning this thread into another "buy an off the shelf solution" I want to be the solution!

Thanks for your help,
Sam

 

[G37Sam]

Thanks for your help Pat.

Another issue I foresee running into would be when reporting transactions as depending on the transaction type, the linked table should vary to retrieve payee's info.

For example, if a transaction is a salary payment, it should link to employee's table to retrieve employee name & info whereas when it's an invoice payment, it should link to the suppliers table to get supplier info.

Is there a way to do that "on the fly"?

 

[gemma-the-husky]

generally speaking, i would not bother trying to build an accounting package.

there are very good reasonably priced ones available.

if you are still interested though, i can give you a link to my fully featured general/nominal ledger. I don't want to market it for the above reasons. I am happy to give it away to anyone interested.

it records journals entries, including reversing journals, exports TBs, profit statements etc.

pm me, if you want it.

 

[G37Sam]

Thanks Pat, I figured that was the only way to go with it, is it good practice though?

Thanks for your offer Gemma, but I'm not really looking into something that deep. Just recording payments and income from hair services.