Data model for a double-entry bookkeeping system in Excel/PowerPivot?

Use this forum for any general discussion and questions about Excel
pqv
Posts: 1
Joined: Sat Sep 01, 2018 10:42 pm

Data model for a double-entry bookkeeping system in Excel/PowerPivot?

Postby pqv » Sat Sep 01, 2018 11:40 pm

The technical goal that I want to achieve is as follows. Note that this is a superficial example for technical explanation only:

I have three tables in Excel. One is called Expenses, and the other two are called Food and Candles respectively. Each table has the columns Date, Payee, Amount and Transfer. The Transfer column accepts table names only. If I buy some food and candles, appropriate entries should be made in the Expenses table with each transaction properly referenced in the Transfer column ("Food" and "Candles" as appropriate). The transactions then show up in the relevant Food and Candles tables, each with "Expenses" referenced in the Transfer column. Data added to any of the tables in the worksheets appears in the other relevant table(s).

Image

Can this be done with PowerPivot and Power Query, and if so please could someone explain how? Thanks.

MattAllington
Posts: 985
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Data model for a double-entry bookkeeping system in Excel/PowerPivot?

Postby MattAllington » Wed Sep 05, 2018 12:14 pm

Interesting. Can you post a sample workbook?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “Excel”

Who is online

Users browsing this forum: No registered users and 3 guests

cron