L P Luigi Espenlaub
My feedback
6 results found
-
76 votes
Gnucash currently provides Experimental Balance and Income Statement (= Profit & Loss) reports that support displaying multiple columns.
They are still experimental because of some glitches with price calculations case of multi-currency or stock market scenarios. If you don’t have those, the experimental reports probably will give you what you need.
An error occurred while saving the comment L P Luigi Espenlaub
supported this idea
·
-
24 votesL P Luigi Espenlaub
supported this idea
·
-
17 votesL P Luigi Espenlaub
supported this idea
·
-
269 votesL P Luigi Espenlaub
supported this idea
·
An error occurred while saving the comment L P Luigi Espenlaub
commented
GnuCash Function Requests
My only concern is "not bouncing checks by having a $200.00 buffer in the account at the usual low point of the monthly cycle."The only thing that has worked for me in either Quicken or GnuCash is using the Scheduled Transactions or Reminder function. My reading has confirmed that several accounting pros have noted budgeting software is not really designed to do what I call "Low Monthly Balance Estimation."..
I Schedule transactions for when I expect them in the 30 days before the next expected low balance date. Once all of the scheduled transactions have been entered in the Scheduled transactions window with their amounts and dates. I run "since the last run" and can then scan the balance column to see if there is any red entries and at the Projected Minimum at the bottom.
Secondly I have scheduled Budget transactions for things like groceries, OTC medications, pet food. Things that can bust a budget. As these transactions come in I subtract those amounts from the "budgeted amount" in the Scheduled transaction. When I have zeroed or come close, I know to watch that spending, or delay the next purchase until after the next expected deposit.
The only headaches I would like a programmer to explore a fix for me are:
1. 1. When importing from a bank, the Match existing transactions keep the Scheduled Transaction information, not the Banks transaction information which loses the check numbers mainly.
> My work around is not to match any transactions and delete the Scheduled versions.
2. 2. I think as in Quicken the Projected Minimum cannot be set for The Projected Minimum on a particular day of the Month or EOM.3. Having to subtract transaction amounts from the budgeted Scheduled Transactions is a headache I would love a set of algorithms to do for me [call it something else beside budgeting]. [
I worked around Programmers for 30 years, know most of the lingo, and still consider what they do as magic smoke and mirrors that happens to work most of the time.] -
2 votesL P Luigi Espenlaub
supported this idea
·
-
2 votesL P Luigi Espenlaub
supported this idea
·
--Provided by Anthony Dardis
[Copied to here by L P Luigi Espenlaub]
As of GnuCash 2.6.15, the Tutorial & Concepts Guide contains a Reports chapter. Please refer to the Guide for details about the reports included with GnuCash.
A single report that shows summary amounts for multiple months for multiple accounts
To create a single report that shows summary amounts for multiple months for multiple accounts (for example, monthly totals for expense accounts over the course of a year), you can use the Transaction Report
Choose your Accounts as the Accounts source in the Accounts tab, e.g. highlight "Expenses" and click "Select children"
Set sortkeys in the Sorting tab: Primary key is Account Name, Primary subtotal is enabled. Secondary key is Date, secondary subtotal for date key is Monthly
Enable Subtotal table in the Display tab
I found this at:
https://wiki.gnucash.org/wiki/Using_GnuCash
I also recommend In the General Tab, enable Table for Exporting.
This will allow you to copy and paste the multi-column table including totals and the Averages column into a spreadsheet program
This is desirable because there is no way presently to disable the pages long detail lines that display below the table.
LuigiWriter