This blog is where we write down what we have learned building Moneylogz: how to keep your financial data in the tools you already use, and how to turn it into answers. Every guide teaches the manual way first, so it is useful even if you never sign up.
| Topic | Where it lives | What the guides cover |
|---|---|---|
| Spreadsheets | Google Sheets add-on | Budgets, categories and reports built on your own sheet |
| Boards | monday.com app | Tracking accounts and transactions next to your projects |
| Dashboard | Moneylogz app | Accounts, transactions, documents and analytics in one place |
If your sheet has a Transactions tab with the date in column A, the category in column C and a signed amount in column D, this totals one category for the current month:
=SUMIFS(Transactions!D:D, Transactions!C:C, "Groceries",
Transactions!A:A, ">="&EOMONTH(TODAY(),-1)+1,
Transactions!A:A, "<"&EOMONTH(TODAY(),0)+1)
EOMONTH(TODAY(),-1)+1 is the first day of this month and EOMONTH(TODAY(),0)+1 is the first day of next month, so the formula follows the calendar without editing.
Budget tab."Groceries" with a reference to the cell next to it, such as A2.What will the Moneylogz blog cover? Practical guides for tracking personal and business finances in Google Sheets, monday.com and the Moneylogz app, including spreadsheet formulas you can copy.
Do I need Moneylogz to use the formulas in these guides? No. Every formula works on any sheet with a date, category and amount column, whether you fill it by hand, from a CSV export or with Moneylogz.
Questions or ideas for a guide? Contact us.