[GNC] automatically account for gst on random purchases
flywire
flywire0 at gmail.com
Sun Jun 18 07:37:44 EDT 2023
https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278
"GnuCash is for tiny and simple enterprises; we often say individuals and
sole proprietorships. Even having employees makes using GnuCash a dubious
proposition (no payroll module), as does carrying more than a very few line
items of inventory (no inventory module) or performing any sort of
manufacturing (no bill of materials or cost accounting modules)."
GnuCash supports GST for Accrual Accounting but not Cash Accounting, go
figure.
---------------------------------------------------------------------
I proposed a process for Cash Accounting with Automated GST:
https://lists.gnucash.org/pipermail/gnucash-user/2021-September/097666.html
TLDR; Automate GST for cash accounting by preprocessing transactions to
enrich with GST and import as a multisplit file
1. This isn't going to work on random transactions, you need to know which
accounts have GST
2. I already preprocess bank transactions in a spreadsheet before importing
but I haven't got around to splitting for GST (because I still use
QuickBooks for business)
3. I'd probably do the splits in python and integrate it into LibreOffice
Calc
If anyone is interested I'll work on it.
> https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107405.html R
Losey wrote:
>
> You MIGHT be able to get fancy by getting the data into a spreadsheet,
> having macros to assign the GST and travel categories, and then import the
> spreadsheet into GnuCash.
>
>
> https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107404.html
Karl May wrote:
>
> > For my business setup I am wondering whether there is a way to
> > automatically
> > account for gst on small random purchases (e.g. hotel, restaurant etc.).
> >
> > My current setup is roughly
> >
> > Assets:financial_assets:bank_account
> > Assets:financial_assets:gst
> > Expense:travel
> >
> > So far I haven't setup Accounts/payable and Accounts/receivable.
> >
> > The current process is:
> >
> > A) import bank account transactions via OFX into "bank_account" and
> > "imbalanced"
> > B) manually go through all transaction, use "split transaction",
manually
> > calculate the gst and assign amounts to Expense:travel and
> > Assets:financial_assets:gst.
> >
> >
> > Any suggestions how this can be automated such that the default is a
> > transaction split and application of a default GST rate?
Regards
More information about the gnucash-user
mailing list