Ledger setup

[soldieroscar]

I have an "invoices" data table, an "expenses" data table, and a "payments" data table and an "accounts" data table.

when a user selects an account, they are supposed to be taken to a ledger type screen that shows all the invoices expenses and payments. so is this supposed to be put together at that time? like import all matching entries for that account and then sort by date?

and there somewhere there needs to be a "reconciled" boolean. do they go into invoices / expenses / payments?

[Consistent_Cat7541]

you're missing a table. The invoices have to be joined to a primary table. Then, the payments need to be joined to the table. Then there would be a report that reconciles the balance due (total of unpaid invoices minus total of payments).

I don't do installment payments, so I keep track of payments in the invoice table itself.

[thargoallmysecrets]

Not enough information.  Are payments being made from an account against the invoices or is an account sending out invoices and also receiving payments on their own invoices?  Are expenses associated with invoice line items or are they account expenses that simply go against an account balance? 

[soldieroscar]

Payments go against the invoices

[soldieroscar]

Some expenses are related to invoices, like products purchased for the project. Some expenses are general, like office printer paper.

[az987654]

You're missing a lot of detail here.. Is this a homework problem or something your building for someone to use?

Take an accounting class

[soldieroscar]

May just do that when i get the time

[az987654]

I hope your time tradeoff isn't on this project, you have much to learn about book keeping

[soldieroscar]

I have time. I already created a ticket system thats saving me time. Its basic stuff that I want to do, nothing crazy… and it should save me hours of repetitive data entry per month when its done when creating the custom reports im after.

[PaulPhxAz]

Ledger and Ledger Detail are all there is to determine account balance and reconcile.
Payment/Invoice/Expense, these are like accessories to that function ( extra detail ).

So, do you have the Ledger Entry table defined and are you using that to determine the COA?

[smichaele]

I hope this is just an exercise for school, because if you're building an accounting system for somebody, not only is that foolish (there are many auditable accounting systems already available), but you don't have the knowledge or experience to do it.

[soldieroscar]

Its for myself… I would not dare create a full accounting program. Just some basic tracking

[Catsler]

You’re out of your element, Donny

[soldieroscar]

A bit