TLDR; Automate GST for cash accounting by preprocessing transactions to
enrich with GST and import as a multisplit file
GST effectively doubles the number of transactions so you'll want automated
gst calculations. Automated gst has been arbitrarily restricted to business
finances in GnuCash which
I've had success importing csv files with
https://github.com/sdementen/piecash
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If
David, good suggestion to split the task:
1. Get accounting advice on needs - how to structure business accounts and
required processes
2. Select software and set it up
Just because your accountant can advise you on the best accounting setup
for your business doesn't necessarily mean their
> *I successfully transferred from Quicken to GnuCash years ago, with no
> troubles. I'm a home user, nothing complex.
*>>* Is there any reason I should upgrade from Version 3.8? Are the
changes mostly for business folks or are there changes that a home
user would enjoy?*
It's continual
I posted a piecash example I wrote to create a book from csv:
https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097124.html
One of the good things about piecash is it's scripted so you get the same
result every time without any wayward keystrokes, It only takes a few
minutes to install
That's my understanding of accrual accounting. The GnuCash Tutorial and
Concepts Guide, Part III, Business Features explains how it works, includes
a tutorial.
Discussed in a recent thread:
https://lists.gnucash.org/pipermail/gnucash-user/2021-June/096943.html
continuing
Stephan, you're right, you can't. Try python -
https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097124.html
Email me directly if you want support. Splits are a bit different.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update
Hack Financial / Fiscal Year in all Reports -
https://lists.gnucash.org/pipermail/gnucash-user/2021-October/097880.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
I've been using this hack which changes the definition of current and
previous year in reports to start 1 July. It will be overwritten each time
a new version of GnuCash is installed and it's unlikely to work with the
next major release.
Find date-utilities.scm eg C:\Program Files
Arthur, that's a nice summary of a
https://en.wikipedia.org/wiki/Reflowable_document
The issue has been raised and
https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was
offered as a format. Does it work on a Kindle?
___
gnucash-user mailing
Your reports show Expense:X and Asset:Tax Collected (but not reimbursed).
Why do you want to budget for tax if it is reimbursed with a net cost of
zero?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to
I raised this issue because despite asking users to search the mailing
lists this demonstrates the provided searches have little value. I followed
mailing list search instructions -
https://lists.gnucash.org/mailman/listinfo/gnucash-user (note Nabble is
inoperational and the only other search is
> Is there any documentation concerning the CSS-based
stylesheet (experimental)? Is this an area a mug punter like myself should
be playing with?
CSS is discussed in
https://wiki.gnucash.org/wiki/Custom_Reports#The_Report-Renderer but
be careful because the wiki documentation is broken so you'll
...and Mailman3 provides a forum-like interface with direct replies through
the interface.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Looks like it needs a Dividend contra account which should cancel itself
out or be ignored in reporting:
Dividend Date Deposit into Bank account from Dividend account
End Previous Year Date Deposit into Dividend account from Component splits
>
___
In Australia ETFs operate under a trust structure, so distributions
received in the new fiscal year are income for the previous tax year. Being
tax, there are many splits associated with each transaction. (Essentially,
if the year was changed to the previous fiscal year it would be reported
for
I previously mentioned piecash will easily import csv transactions. It also
creates the account structure in the process.
piecash is a GnuCash compatible python library. It doesn't use GnuCash but
creates files that are compatible with GnuCash. piecash is an alternative
to the python bindings
This mailing list is for discussion. I suggest you raise an enhancement
request: https://wiki.gnucash.org/wiki/Bugzilla
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
> Why not just use the built-in importer?
Won't run without manual input. Anyway, this just demonstrates one process.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
You could have also picked a different field separator eg Semicolon (;)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are
What do you need Weiwu? eg Bookkeeping familiarity, type of business,
number of enterprises, cash or accrual tax accounting, gst registered,
number of bank accounts.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription
You're on cash accounting for tax. Two GnuCash limitations compared to
other packages you need to understand:
1. No automated GST support for cash accounting (it's manual):
https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097092.html
2. No support for non-account transaction
GnuCash integrates with bank statements so you won't miss any small
amounts. GST is automated for accrual accounting but not for cash
accounting. I wouldn't expect it to be a big programming job to enable,
just not a current priority for any developer.
OP, Have you looked at other software? Next you'll be looking for Bug
113772 - Add categories for more reporting flexibility,
https://bugs.gnucash.org/show_bug.cgi?id=113772 .
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your
Try part of the qif file at a time.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
Test one and a few records too.
Alternatively, you could try csv format.
On Tue, Jan 18, 2022 at 9:50 AM flywire wrote:
> Try part of the qif file at a time.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscr
Arthur,
Your original message was clarified to be about automatically posting
weekly rent so a rental statement can be produced with the balance of the
account at that date. This is a very simple schedule of regular dates and
amounts but GnuCash can't do it without manual workarounds.
Excellent question Arthur. This isn't a budget issue and you have no idea
if tenants are in front or behind unless you compare it to payments
due. Adrien seems to have presented the GnuCash features the best using a
scheduled A/R.
I've used a different approach with quickbooks for this purpose
https://wiki.gnucash.org/wiki/FAQ#Q:_How_can_I_print_a_Rental_Statement_for_my_Tenant.3F
A start.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Thanks all, that contribution fits much better there and it's well
supported by the tip above it. Ultimately, private rentals are
probably common enough for it to be worthwhile supporting this
feature directly.
I'll offer a few comments for consideration. There was a fair amount of
discussion on
https://wiki.gnucash.org/wiki/Custom_Reports - it's broken when you get
down into it.
There are two basic reports, the transaction report, and most of the
others are based on the income and expense report.
___
gnucash-user mailing list
This:
https://wiki.gnucash.org/wiki/Custom_Reports#Technique_to_reload_reports_without_restarting_GnuCash
Except for the bash script the process works the same in Windows as linux.
The code comments work well:
> This farm has over 10 vehicles that we'd like to keep track of gas,
maintenance and tax expenses...
> I've read that using other softwares one can benefit from "category" to
better filter the information you want and create reports...
It's not so much filtering, more grouping of cost components
> On Feb 1, 2022, at 1:47 AM, Don Robertson wrote:
> Well, I guess it isn't for me. I think computers should save people
time. If I need to open my bank page in my browser and copy the
transactions manually into Gnucash and make a bill, post it, and pay it
for every packet of paperclips
> I've read that using other softwares one can benefit from "category" to
better filter the information you want and create reports
One of the workarounds previously discussed is to add a tag [ie category]
to the split notes, it's just under the description in the account
register. A transaction
> How many "classes" can be assigned to the same account? In
other words, can an account be a member of many different "classes"? If
that is not possible, if only one, then it should be obvious why an
accountant would find pretty useless.
Rest assured, classes have nothing directly to do with
https://bugs.gnucash.org/show_bug.cgi?id=113772
Try https://kmymoney.org/
On Tue, Jan 18, 2022 at 1:07 PM Greg Feneis wrote:
> Also, I'm not sure, but I don't think GnuCash has a facility for
> QuickBooks' or Quicken's categories
>
___
gnucash-user
The first two sections of the GnuCash Guide
https://www.gnucash.org/viewdoc.phtml?doc=guide are a tutorial to introduce
accounting and the application respectively.
The whole concept of reconciling a cheque account is very dated in a time
when countries move to abandon cash, but it covers the
I got sick typing into a spreadsheet so I got the app to extract the data
directly from the pdf to create the transaction splits:
https://github.com/flywire/ETF-Annual-Statement
One line of code will compile it into a Windows *.exe to avoid python if
anyone wants it. There is a start on a gui
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109173.html
David Cousens wrote:
> I would suggest you read at least the introductory sections of the
GnuCash Tutorial and Concepts guide under the heading Basics
https://www.gnucash.org/viewdoc.phtml?rev=5=C=guide
I doubt many people
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109255.html
Alan Hopkins wrote:
> I know an accountant who has, for at least one business, accepted printed
P & Balance Sheet from a 2002 version of Quickbooks together with end of
year bank statements - he has never wanted to get the
* https://wiki.gnucash.org/wiki/Using_GnuCash#Printing_a_Rental_Report
* https://github.com/dawansv/gnucash-custom-reports
JC wrote:
> I really wished that GC would have the option to link Vendor/Customer to a
> transaction without creating a bill or invoice. Any future development
> plans for
Also, https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107567.html
would probably readily adapt for commission.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
://github.com/flywire/ETF-Annual-Statement from tax
statements, both for csv import.
Given Python bindings are not available in a binary they are really a fake
feature and https://piecash.readthedocs.io is not genuine GnuCash so you'd
have to get support from that project
JC writes :
> If using QuickBooks in which you can assign a transaction to a
> vendor/customer, I don't have to create invoices and bills just for the
> sake of tracking the payment sources and targets.
Yeah, the GnuCash business workflow seems a crazy complicated manual
process coming from
The process works but the Price Import Assistant Summary description and
poor user interface labels are confusing. I use csv import all the time but
this is so bad I can't understand it.
[the minimum columns] are Date, Amount, From Namespace, From Symbol and
Currency To. If all entries are for
Yes Ove, clearly there is more to it as demonstrated by your example.
I can see the importer is using Commodity, Price Database uses Security,
and Security Editor uses Namespace and Symbol.
https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help
much.
Can we focus this back on improving the clarity of the Price Import
Assistant? The first page is essentially the full documentation of the
process.
https://github.com/Gnucash/gnucash/blob/5.4/gnucash/gtkbuilder/assistant-csv-price-import.glade#L55
uses the column labels: Date, Amount, From
While importing csv files is only really explained in the manual
https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv
(not the guide) in terms of transactions, there is a lot of supporting
information for the Price Import Assistant in
I have loaded my stock portfolio into GnuCash for tax reporting purposes.
I'd like to update stock prices annually by importing the closing value for
30 June from a csv. Can someone give me a rundown on the required input and
process? I'd be happy to add it to
I'll work with the Price Import Assistant druid. Is it actually documented?
I found https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109184.html
Edwin Booth wrote:
> I need to wrap my head around the whole “debit/credit” concept.
No you don't but you do need to understand the concept of account types and
moving money between them. I've studied economics at Uni,
A classic case for a single file with tags:
https://github.com/Gnucash/gnucash/pull/1623
It works but it is not part of standard GnuCash.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
> it's already available as a custom report which I will maintain for the
time being: https://github.com/dawansv/gnucash-custom-reports
On Mon, 14 Aug 2023 at 09:57, flywire wrote:
> A classic case for a single file with tags:
> https://github.com/Gnucash/gnucash/pull/1623
>
A couple of years ago
https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was tested (as
external help) but there was no interest.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Two things you need to consider before deciding to switch:
1) classes are not supported and the workarounds won't do grouping for
reports (ie list all transactions ordered by workaround for class)
2) with cash accounting there is no automatic tax (GST, sales tax, VAT
etc), it only works with
Firstly, an accountant won't know how to use GnuCash unless they are a user.
Have you done the GnuCash Tutorial and Concepts Guide as an introduction
for Getting Started and Managing Personal Finances? Put it in a window on
one side of your screen and start a new GnuCash file in a window on
the
TLDR: GnuCash Windows version is compiled on linux so, considering the
note below, you are unlikely to get python bindings working in
Windows.
> Important
> The Python extensions are an optional feature which creates additional
> dependencies. To be
> able to use Python scripts, GnuCash must
Is a crash in the import system part of the autosave scope?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble
Seems you are following
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv.
Figure 6.5. The CSV Import Preview Pane is hard to read so click
https://www.gnucash.org/docs/v4/C/gnucash-help/figures/Help_CSV_Import_transactions_Preview.png
to view it in a new tab.
*
>* the original remains in the Tutorial and Concepts Guide. It should have been
*>* removed...*
David,
Thinking about this again. How about a section which imports the
tutorial transactions from csv referencing the help manual? Maybe an
export/import with multi-splits. It would complement the
I think the GnuCash Tutorial and Concepts Guide is an excellent
introduction for Getting Started and Managing Personal Finances. The small
dataset demonstrates a lot. The only thing that really looks dated is the
checkbook-style transaction descriptions which are very different to modern
bank
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html
is part of a discussion on classes.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
The three lines below work using a Multi-split import - based on
https://bugs.gnucash.org/show_bug.cgi?id=797450
Save *PP-Demo_Transactions_Minimal_Priced2.csv*:
Date,Description,Action,Account,Deposit,Rate/Price
01/02/2021,RIO,,Assets:Broker:Funds,-9912.53
I uploaded the spreadsheet I've been using and a python program I wrote to
https://github.com/flywire/ETF-Annual-Statement
It's basically just a lookup and pivot table saved to csv using rounding as
an error check (credit to Chris Grinton). It could easily be extended to
automatically extract
> Does the CSV importer handle floating point values for amount and price
or do I need to use integers?
Floating point works fine for me in all amounts except price:
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102535.html
> e.g you'd write $497.65 for 57 shares as 49765/5700
Did you carefully work through the known working process described in the
bug report Comment 3 using the file below?
The broker csv file almost certainly needs manipulating. The best approach
is to enter the data into GnuCash, and then export the account to csv. You
can use the exported csv to
Try Reports, Account Summary
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102526.html
> CSV stands for "common separated variables.
> data must be in the right order AND any data that is null (not present
still has its space in the record.
Hmm:
* Comma separated variables -
Since I use cash accounting I don't have any experience with GnuCash
invoicing. I process heaps of invoices, including recipient-created
invoices. Tax-inclusive or tax-exclusive costs are optional in Quickbooks
(which I use for business accounts) and calculated values can be user
overwritten. I
>* - BUT: For income and expense accounts, multi-currency accounts seem to be
*>* a total disaster. Why? Because all PAST transactions on both income and
*>* expense accounts will be valued at the CURRENT exchange rates.*
Simply recording value in local currency works for me. You can add a
The process needs to be right before worrying about the accounts:
1. If your tenant is reluctant to pay rent find a new tenant, no
different to any other business clients that are hard work.
2. Weekly tenant notices with the amount owing seems more like
harassment, and too much work
Try https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097442.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
This is similar to rental payments but my experience is with cash
accounting. It is easy to skip an invoice and in my jurisdiction, this
eventually means it isn't required to be paid. I'd suggest providing a
statement instead of pairing payments and invoices so payments are applied
to the oldest
Re: https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102045.html
> You're correct that the Python bindings aren't included.
I'd be happy with a non-standard download available that included the
bindings. It wouldn't need gui support.
___
That never used to be the case but it's still pretty useless for a tax
return:
Please note that if you wish to download transactions that is more than the
12 month period, you must choose the 'View Statement' option. However,
please be advised that it does not have the facility to transfer them in
Oh, security isn't a thing anymore? Maybe supply your DOB and mother's
maiden name too so they don't have to get it from social media.
On Sun, Aug 7, 2022 at 09:09 Christopher Lam https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
wrote:
>* You may try this service which is free for
They look big numbers. I wonder if it's an overflow issue.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to
Share software can manage shares and show all sorts of interesting things.
I use Portfolio Performance portfolio-performance.info/en/ and Sharesight
sharesight.com is also popular.
Portfolio Performance easily imports broker trade pdfs (Sharesight even
strips emails or uploads a hot folder) but
Jim, this overlaps with what I was putting into
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102404.html so
I stripped the data exchange part out. The sample data sets and references
might still be useful.
The GnuCash GUI won't import security data so in addition to what has been
I'd appreciate any comments if this could be able to be managed as a single
portfolio (ie one security). I can't get it to work without entering every
share.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription
Once share securities are created the share accounts can be created with
File, Import, Import accounts from CSV.
File, New
Cancel
Tools, Security Editor
Securities: Add
New security
Full Name: ***
Symbol: ***
Type: *** - Sticky
Fraction Traded: ***
OK
File, Import, Import Accounts from CSV
I haven't used GnuCash securities before the last week and I'm still not
clear about them. I understood importing security entries were
transactions. Further to my last post with minimal security information the
fraction traded is not required.
I hadn't realised importing transactions with
Obviously it wasn't clear that the post copied below identifies the
keystroke operations from opening GnuCash through the Security Editor with
*** as user input. The Import accounts was an aside comment. (Thanks David
for start the account tree comments.) Interestingly New security is one of
the
This might be a TAX issue but financial reporting is very much a GnuCash
issue and has nothing to do with tax advice. Different terms being used for
the same thing in different jurisdictions complicate the discussion, and
then the taxes actually vary.
I've managed to move most of my spreadsheet
Thank you for the discussion. To clarify, these ETFs are index funds:
https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205=prices-and-distributions
I don't see the point of entering the attribution values since they don't
exist in the bank statement or tax return.
A contra account
This Account Summary demonstrates the last part of the need to distribute
all [Family] Trust income from the ETFs.
Note:
1. ETFs have been manually revalued at the end of the tax year (after
working through
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html )
2. Distributions
My Citibank statements are only available as pdf and I use
https://github.com/flywire/pdf_statement_reader . It is based on tabula and
forks another project to make it functional. More config info at
https://github.com/marlanperumal/pdf_statement_reader/issues/34
More cat skinning:
>* the ability to have two separate (at least) GnuCash file systems:
*
In Windows (or probably any GUI) double-click file in data folder and it
will use file association to open the file (in GnuCash).
Alternatively, for each file: right-click file, create a shortcut, drag
I'd expect there are easier invoicing packages, but you will likely need
much more. I don't know why there is no tutorial for GnuCash business
features (which only support accrual accounting) but each feature has an
example transaction. I don't use those features and agree, they seem
confusing.
https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103049.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
It is my understanding certain legal documents need an amount to be
effected but normally it is not actually paid, so there would be no £1 in
the books. It probably becomes an unpaid invoice or loan but that's
lawyer/accountant detail.
___
gnucash-user
https://wiki.gnucash.org/wiki/Using_GnuCash#Tracking_Reimbursable_Expenses
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
See first part of
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html
re tags for most practical workaround. You could use multiple tags on one
split to get all or particular trips, eg: #trip #cruise. As noted, there is
no support for grouping (ie display all transactions in
Make sure you understand what Gnucash offers as it could be a
massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for
different books because neither has all the features I need. Specifically,
GnuCash does not support classes or automated GST (tax) for cash accounting
(so I've
There is no panacea for replacing QuickBooks with GnuCash but I'm starting
to warm to the workarounds:
* https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html
- use tags instead of classes, the transaction report is the only one that
supports filtering so other reports would
The guide isn't really enough. Try these (checking the attachments) and
follow the last thread:
* Dividends -
https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097500.html
* Trusts (eg ETFs) -
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102563.html
* Portfolio -
The Transaction report has an option to hide transaction data and just
report Account totals; Option, Sorting, Show subtotals only (hide
transaction data). Prefixing all lines with "Total for " and highlighting
them makes the report harder to read.
I tweaked
R Losey wrote:
> You need to make sure that your... stock is set up as an account type of
> "Mutual Fund" or "Stock"
No you don't, dividends can be entered into a dividend account like any
other transaction. The main feature of a "Stock" account type is easier
revaluation of a portfolio, ie
Common advice is don't mix personal and business bank accounts but almost
everyone does with personal tax. You could do what you want with a business
account under each top-level account or bank account then report against
those accounts but it would be fiddly.
It is a classic class issue, ie one
101 - 200 of 281 matches
Mail list logo