Share via

make ledger book

Anonymous
2024-10-04T17:08:42+00:00

In MS access I want ledger book. in ledger book i want to manage my all customer with debit credit entry balance and can download particular customer report with starting to ending in report have SN, date, Description, debit, credit, balance

<spelling>>

Microsoft 365 and Office | Access | For education | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,220 Reputation points Volunteer Moderator
    2024-10-04T17:57:01+00:00

    Are you looking for a template? Are you asking for advice? Why not look at an off-the-shelf product such as Quickbooks, which does all that already.

    0 comments
  2. Anonymous
    2024-10-04T23:20:08+00:00

    If all you want is a simple ledger of the type you describe, then you might like to take a look at Balances.zip in my public databases folder at:

    https://1drv.ms/f/c/44cc60d7fea42912/EhIppP7XYMwggESpAAAAAAABaDKZCllSuweYBPJ5zKa3cg

    This little demo file  illustrates a number of queries for computing balances. That using 'single table with credit & debit columns for amounts - grouped - read only' would provide the basis for a report per customer such as you describe.  This joins two instances of a TransactionsCD table with columns TransactionID (PK), TransactionDate, Credit, Debit, and CustomerID (FK).

    If, on the other hand, you want a fully featured accounting application, I'd agree with George that a product such as QuickBooks, Sage etc. makes more sense than trying to reinvent the wheel in Access.

    0 comments
  3. Anonymous
    2024-10-05T01:19:43+00:00
    0 comments