New Report. Suitable for VAT/GST returns.

2017-07-31 Thread Christopher Lam
rison Stuber ;; Modified account names display by Tomas Pospisek ;; <tpo_...@sourcepole.ch> with a lot of help from "warlord" ;; Heavily amended by Christopher Lam to calculate add calculations ;; appropriate for GST/VAT, building on efforts by Doug Doughty. ;; ;; This progra

Re: Adding quantity to expenses

2017-08-02 Thread Christopher Lam
You can also abuse the Currency feature. Create account called Assets:Cheese (currency CHF sounds appropriate!). Amend its symbol to 'kg'. Transfer from USD $8 in Assets:Bank to 0.8kg in Assets:Cheese, and the commodity editor will pop up ($10 = 1kg). Eating cheese means transferring some kg

New Report ideas

2017-06-29 Thread Christopher Lam
Hi Doug I'd be keen to hack scheme to modify the source "Accounts" tree which is common to several report types. Right now you select your originating accounts, and when you 'save' the report options, the account guid are hardcoded into the options. This causes issues if we modify the chart of

Re: Question on multiple layered searches and exporting

2017-08-09 Thread Christopher Lam
> > So my questions are: > > 1) Is there anyway I can make each search I do output it's results to a > new tab so I do not have to start all over after getting 5 layers deep in a > search if I screw up? > No... usually you would search transactions for quick lookups ("warranty claim... when did

Re: New Report. Suitable for VAT/GST returns.

2017-08-09 Thread Christopher Lam
https://forum.manager.io/t/indian-gst-tax-code-tax-summary/10315 This seems to show exactly what my report produced :-) And the attached chart of accounts seems to fit the bill. Just make sure you assign the correct tax account per multisplit transaction. In my updated report you can merge all

Re: New Report. Suitable for VAT/GST returns.

2017-08-02 Thread Christopher Lam
at 20:22, Christopher Lam <christopher@gmail.com> wrote: > Hi All > > After many years of trying to hack scheme, I've finally been able to > create a custom report building on previous efforts by Doug Doughty. Report > is accessible in Report > Business > BAS/VAT Rep

Re: Accounting for contractors using GnuCash?

2017-07-28 Thread Christopher Lam
I have an interesting solution for recording mileage within Gnucash. I presume you have something like Expenses:Business:Travels already set up in your local currency. You could create an account called Expenses:Business:Mileage in currency XXX, and it will contain only mileage records. It

Re: New PC

2017-06-07 Thread Christopher Lam
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/basics-migrate-settings.html#App-sett-loc On 7 June 2017 at 19:34, Edwin Humphreys wrote: > I have GnuCash on an old PC, which I am now replacing. I can download > GnuCash onto the new PC, but how do I transfer my old finance

Re: Reconciling an account

2017-06-07 Thread Christopher Lam
Perhaps you may share a partial screenshot of your liability account register? Zap confidential data, however, some data has already been shared :) On 7 June 2017 at 10:26, EngineInstitute wrote: > Dave, > No worries about raining on my parade. > I figured it was probably

Re: Transaction Journal View - blank "Memo" instead of Description

2017-06-11 Thread Christopher Lam
> > It would be nice if I could double-click the invoice line and open the > invoice, maybe I am missing something? > > That would be nice too. I agree. Please file a Request For Enhancement on Bugzilla. You can open the *Bill or Invoice* associated via roundabout way 1. Highlight appropriate

Re: New user questions

2017-10-04 Thread Christopher Lam
Re: mileage recording I record business mileage using an unused currency (ZMK, whose display symbol I've changed to 'km') - this means I maintain one datafile rather than multiple spreadsheets, and using a different currency avoids accidentally mixing up numbers. If I visit my accountant,

Re: importing

2017-10-14 Thread Christopher Lam
There should be no need to delete the Trading Accounts. It only exists if you have set File>Properties>Use Trading Accounts to true, and you have transactions that involve a currency/stock conversion. The transactions in the Trading Accounts are harmless, and are even useful when performing some

Re: Add icon for "Get Transactions..."

2017-09-09 Thread Christopher Lam
Ah but there exists mechanism to add keyboard shortcuts.Edit your .gnucash/accelerator-map and maybe you'll find appropriate entry. I've added Ctrl-J for Jump as Ctrl-L for Split as follows: (gtk_accel_path "/GncPluginPageRegisterActions/JumpTransactionAction" "j") (gtk_accel_path

Re: How to deal with the cash flow and the credit card.

2017-09-25 Thread Christopher Lam
I think the easiest way is to schedule both repayments as you expect to pay the credit cards in the future (23 and 30 of the month). Then on the main Accounts window, enable the column labelled "Future Minimum" which will warn you how close to the red line you will be :) (Click on the down arrow

Re: Report Question

2017-09-30 Thread Christopher Lam
Edit > Report Options > Display > Maximum Bars (default 8) Set it to a higher number, the maximum is 24 On 30 September 2017 at 20:22, Joseph Hesse wrote: > Hi, > > I am using the latest version 2.6.17 of gnucash. I just ran the report > "Expense Over Time = Expense

Re: Trouble with custom report options

2017-10-01 Thread Christopher Lam
This is a bug that's been fixed in 2.6.18 There's more than a few report writers now :) https://bugzilla.gnome.org/show_bug.cgi?id=647805 On 2 October 2017 at 05:55, Jon Schewe wrote: > All, > > I'm trying to create a report with some options that are disabled when > others

Re: Report - Items sold, quantity and value

2017-10-11 Thread Christopher Lam
You can print a report of itemized sales in one invoice by running the Reports/Business/Tax Invoice report. I don't think there's a report which will aggregate items sold across several invoices. C On 10 Oct 2017 22:04, "Eduardo Estefano Neto" < eduardo.estefano.n...@gmail.com> wrote: > Hi

RE: Reconciliation Report

2017-11-30 Thread Christopher Lam
Hi Rick As per Adrien, there’s no specific Reconciliation Report. You can, however, run the Transaction Report, choose select: - Accounts/Accounts – choose your Bank account (or Credit Card account) - Display/Reconciled Date - ticked - Sorting/Primary Sortkey - Reconciled Date This may help. I

Re: Accounts Capicity

2017-12-01 Thread Christopher Lam
Agree the hard limit is somewhere around the number of atoms in the universe. In the past, where I couldn't get the register to accept a transaction, there was usually an invalid state due to fiddling the settings too much. For example, I was inputting transactions as usual, then changed the

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

2017-12-01 Thread Christopher Lam
This sounds like an overkill. I'd write the original purchase as: Asset:Bank -$430 Asset:GiftCard: $500 Expense:Rebates -$70 Whereby Expense:Rebates generally collects anything that was purchased at a discount, and I wish to record the original price as well as the discount. So, a discounted

Re: Report error An error occurred while running the report.

2017-12-13 Thread Christopher Lam
Not every report handles error conditions smoothly. It would be useful to summarise the report chosen and the options used. The report can then be fixed for the next release. On 13 Dec 2017 4:22 PM, "Dane Dormio" wrote: > I am running the latest version of GNUcash (2.6.18)

RE: Report error An error occurred while running the report.

2017-12-14 Thread Christopher Lam
Just a punt Try increasing the Accounts / Show Accounts until level to “All” Sent from Mail for Windows 10 From: Dane Dormio Sent: Thursday, 14 December 2017 5:15 PM To: sunfis...@yahoo.com Cc: gnucash-user@gnucash.org Subject: Re: Report error An error occurred while running the report. Yes,

Re: Report error An error occurred while running the report.

2017-12-13 Thread Christopher Lam
Also the trace file will be useful. https://wiki.gnucash.org/wiki/Tracefile On 13 Dec 2017 23:40, "Christopher Lam" <christopher@gmail.com> wrote: > Well start by stating which report caused the error. Which options did you > modify. Did you change any global

Re: Report error An error occurred while running the report.

2017-12-13 Thread Christopher Lam
w.danedormio.com On Wed, Dec 13, 2017 at 6:27 PM, Christopher Lam <christopher@gmail.com> wrote: > Not every report handles error conditions smoothly. It would be useful to > summarise the report chosen and the options used. The report can then be > fixed for the next release. &g

Re: Transaction Report with weekly balance

2017-11-19 Thread Christopher Lam
Hi Billsy, Welcome to Gnucash mailing list. Perhaps you can tick Display/Running Balance and it'll show both the transactional amount (+$3500, -$1500 etc) as well as the immediate bank balance (i.e. 7809+3500 and 7809+3500-1500 etc). Note the above applies only if you have chosen your bank

Re: simple find transactions report

2017-11-02 Thread Christopher Lam
Hi Elmar >From the default Transaction Report, choose: Accounts/Accounts: select the Expenses:Discretionary:Travel, click 'Select children' which will select Expenses:Discretionary:Travel:Lodging etc Sorting/Primary Key: Date Sorting/Primary Subtotal: none Sorting/Secondary Key: Description or

RE: Outgoing personal loan clarification

2017-11-02 Thread Christopher Lam
I’d think: 11th: Regular 2-split Assets:Cash -$300 Expenses:Payroll $300 25th: Multisplit Assets:Cash -$50 Assets:Loan:Employee -$250 Expenses:Payroll $300 The loan repayment is simply a transfer between ‘Money owed’ asset account to your bank account. Some concerns will be whether you wish

RE: Categorized credit card spend report

2017-11-03 Thread Christopher Lam
The report you wish does exist. From transaction report: Account/Account – choose Expenses placeholder, click “Select Children” Account/Filter By... – choose your creditcard(s) (either, or both) Account/Filter Type – include transactions to/from filter account HTH From: Tj Junior Sent:

Re: budgeting is very slow

2017-12-11 Thread Christopher Lam
This is nothing to do with your hardware, it's a known issue with budgeting on windows and so far no one has been able to diagnose why. On 12 Dec 2017 11:56 AM, "Dave & Tracy E via gnucash-user" < gnucash-user@gnucash.org> wrote: > Hi. > > > > * The budgeting window on GnuCash 2.6.18 is

Re: Bank reconciliation history

2017-10-30 Thread Christopher Lam
Don't think this information is stored in the database. I think the closest approach is use Transaction Report, enable Display/Reconciled Date, set Sorting/Primary Key to Reconciled date, Sorting/Secondary Key to None. But I don't think the 'reconciled balance at reconciliation date' is ever

Re: cannot find report

2017-10-25 Thread Christopher Lam
on $ 2.00 > 999-1 total for apr $ 2.00 > total for main + sub account $ 3.00 <-- this is the line i'm looking for. > > i remember vagely that i did something like this in the past but i cannot > find it anymore. > > > > On 25 Oct 2017, at 17:12, Christopher Lam <chris

RE: cannot find report

2017-10-25 Thread Christopher Lam
You can run the standard Transaction Report, choose options: Accounts/Accounts: click a parent account, click “Select Children”; ***don’t select any other accounts*** Sorting/Primary Key: account name Sorting/Primary Subtotal: true Sorting/Secondary Key: none This will give you the total for

Re: GNU Reports

2017-10-25 Thread Christopher Lam
Try the "Income Barchart" and enable Display/Show Table On 25 Oct 2017 05:11, "Ron Buchan" wrote: > Hello, > I am new to Gnucash and was wondering if it's possible to produce a profit > and loss report that shows individual months as well as a total. > *Regards* > > > > *Ron

Re: GNUCash Android Companion App Balances

2017-10-22 Thread Christopher Lam
It seems the android developer Ngewi Fet is rather active on https://plus.google.com/communities/104728406764752407046 On 22 October 2017 at 16:35, Mike Stillingfleet < mikestillingfl...@fastmail.co.uk> wrote: > Thank you Colin. Yes I do do regular back ups and thank you for > reminding me to do

Re: [GNC] Advice needed, how to handle a medical reimbursement account...

2018-05-13 Thread Christopher Lam
Hi Randix; you can try using the Business features and see if they work for you, or use an intermediary 'asset'-type account (or more accurately, account receivable). 1-Jan: Income:MRA -$1000 Asset:MRA +$1000 5-Jan: visit Doctor123 Asset:Checking -$100 Expense:Medical +$100 10-Jan: submit claim

Re: [GNC] Custom invoices don't work after upgrade

2018-06-06 Thread Christopher Lam
, is not accepted by any html validator, nor navigable by emacs. Otherwise, it's fine, really! On 5 June 2018 at 20:47, Derek Atkins wrote: > Christopher Lam writes: > > > Try this one... unfortunately most of the report uses eguile which I > can't > > understand. > > I'm curious

Re: [GNC] Rebuild of Gnucash 3.1-1 on Arch fails

2018-06-09 Thread Christopher Lam
Fixed in source https://github.com/Gnucash/gnucash/commit/1f3cf845c4588e787f9b26ad06b05d7cd73326b7 On 9 June 2018 at 23:51, Richard Ullger wrote: > Hi, > > I'm trying to rebuild gnucash 3.1-1, downloaded from Sourcefourge, > following the boost update in Arch, but fails with the error below. >

Re: [GNC] Fwd: The two modules

2018-06-18 Thread Christopher Lam
of numbers that is the problem. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 06/18/2018 06:35 AM, Christopher Lam wrote: Hi Stephen Thank you

Re: [GNC] New User, First Invoice...Cue Weird Music!

2018-06-13 Thread Christopher Lam
Isn't the second X in the first line a mistake? Click to disable (stands for "tax included in amount") On 13 June 2018 at 21:35, Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > I'm a brand-new GnuCash user and I set up a chart of accounts and used > it to draw up an invoice

Re: [GNC] New report

2018-06-15 Thread Christopher Lam
Hi Stephen I cannot help with getting eguile reports loaded, but would be very interested in feedback from a trained accountant. What is wrong with the balance sheet, and how should it look like? Would you be kind to offer an annotated sample? The current reports can be fixed. Regards On 15 June

Re: [GNC] Custom invoices don't work after upgrade

2018-06-01 Thread Christopher Lam
> Here they are. Thanks! > > On 06/01/2018 05:11 PM, Christopher Lam wrote: > > Could you send these customised invoices as an attachment? > > On Sat, 2 Jun 2018, 02:34 Jordan and Reidun Staudinger < > jordanandrei...@harewaves.net> wrote: > >> Hi, I have had s

Re: [GNC] Custom invoices don't work after upgrade

2018-06-01 Thread Christopher Lam
Could you send these customised invoices as an attachment? On Sat, 2 Jun 2018, 02:34 Jordan and Reidun Staudinger < jordanandrei...@harewaves.net> wrote: > Hi, I have had some pretty decent looking custom invoices set up in > GnuCash for a few years now, and I've been quite happy with them. >

Re: [GNC] Custom invoices don't work after upgrade

2018-06-02 Thread Christopher Lam
try Sent from Mail for Windows 10 From: Jordan and Reidun Staudinger Sent: Saturday, 2 June 2018 11:17 PM To: Christopher Lam Subject: Re: [GNC] Custom invoices don't work after upgrade Thanks for your help with this, I really appreciate it. The new one you sent back gives a different error

Re: [GNC] New Balsheet (and P report)

2018-06-30 Thread Christopher Lam
oker:Stock 200FUND" I dare say this strategy is much clearer than the existing balance sheet reports. C On 30 June 2018 at 17:03, Christopher Lam wrote: > Hi Dave > > On 28/06/18 17:24, DaveC49 wrote: > >> Christopher, >> >> " except that Placeholde

Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)

2018-07-01 Thread Christopher Lam
Discussions are useful; but would anyone have an idealised template, or sample output that the balance sheet should produce? Idealy with the 'account-has-children-and-amounts' peculiarity? The balsheet in development will, ideally, replace the current (non-eguile) one. The existing one has amounts

Re: [GNC] Advanced Portfolio: "sell transaction causing a negative stock balance, and a subsequent buy transaction causing a zero balance"

2018-07-01 Thread Christopher Lam
Highlight the "transfer" buy transaction, click transaction duplicate, and accept the exact same day. You now have two buy transactions. Now highlight the first one and delete it. On Mon, 2 Jul 2018, 05:54 Anthony Joseph Messina wrote: > With GnuCash 3.1 on Fedora 28, I encounter the following

[GNC] New Balsheet (and P report)

2018-06-25 Thread Christopher Lam
Seeking beta testers. https://github.com/christopherlam/gnucash/tree/maint-balsheet-pnl Or, anyone with v3.2 onwards can copy the file directly into the build's standard-reports folder:

Re: [GNC] Valuation of stocks, foreign currencies in reports

2018-06-26 Thread Christopher Lam
be parked for now; and merged when it is confirmed accurate enough. C On 26/06/18 17:11, Geert Janssens wrote: Op dinsdag 26 juni 2018 06:03:07 CEST schreef Christopher Lam: Hi Stephen Thank you for valuable feedback... all these issues are cosmetic / account selection, and are relatively trivial

Re: [GNC] New Balsheet (and P report)

2018-06-25 Thread Christopher Lam
haven't done any bookkeeping with multiple currencies. > So will need input from somebody else. > > > > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439

Re: [GNC] Odd behavior on Transaction Report

2018-07-02 Thread Christopher Lam
Hi Stephen The Running balance is directly retrieved from the split data; the ordering of same-day splits is, I believe, dependent on the order of data entered. If it matters try setting one of the sortkeys to 'register order' - it may work but even if it does, the custom sorter will sort

Re: [GNC] New Balsheet (and P report)

2018-06-30 Thread Christopher Lam
Hi Dave On 28/06/18 17:24, DaveC49 wrote: Christopher, " except that Placeholder accounts can also contain transactions therefore must not necessarily accumulate their children account amounts. " I have to disagree with the above from an accounting perspective. I was not describing UI

Re: [GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

2018-05-02 Thread Christopher Lam
> > > While I am at it, I note that the report setting to reverse account > signs on the transaction report doesn’t seem to affect the total amount any > more—it worked correctly in 2.6.19. ISTR that others have noted this—or > does that need to get a bug as well? > > > I'm afraid the previous

Re: Account report error for transactions the last 30 days

2017-10-22 Thread Christopher Lam
Are you using Edit > Find or CTRL-F to search description/account, and use the resulting register (which looks like a normal register) to calculate totals? If so, I think the running balance is rather meaningless. For your particular report I'd use the Transaction Report, depending on whether

Re: Account report error for transactions the last 30 days

2017-10-22 Thread Christopher Lam
Edit > Find and CTRL+F are the same. The resulting search results register does not, in my view, produce very useful running balances. The standard Transaction Report cannot filter by Description. Doug Doughty has some custom reports I've kept at https://github.com/

Re: New to GNU Cash: how do I enter a VAT Payment?

2017-12-30 Thread Christopher Lam
There are various ways. Check the FAQ to determine your preferred method. These relate to recording vat collected/paid during business transactions. https://wiki.gnucash.org/wiki/FAQ#Tax_Handling:_Goods_and_Service_Tax_.28GST.29_or_Value_Added_Tax_.28VAT.29 On 31 Dec 2017 6:58 AM,

Re: Filtered account report

2018-01-15 Thread Christopher Lam
Try the Transaction Report which has an Account Filter in the first tab. On 16 Jan 2018 11:54 AM, "AC" wrote: > I was looking at some of my loans and wanted to get an idea of how much > I paid in interest to each loan over their life. I've got one account > that collects

Re: Reports Not Responding Windows 10

2018-01-23 Thread Christopher Lam
Your account currency is R. Your report currency is $. Your data file has no R/$ price information. That's why. Edit option, change report to R. On 23 Jan 2018 16:52, "michaelwithms" wrote: I have installed Gnucash this morning. All fine except the reports do not carry

Re: Future allocated money vs Budgets

2018-01-26 Thread Christopher Lam
Hi Matt I think there is merit in your idea. I think some of the logic has already been baked into the Scheduled Transactions (SX) facility. So far, we know the transactions in the database are perfect for recording *past* activity. Sometimes I'll also record transactions in the future e.g. for

Re: Collecting payments from others then remitting to one vendor

2018-01-12 Thread Christopher Lam
You could do liability accounts for each utility bill but I like the concept of 'kitty funds' which gives you/them a real-time view of monies owed by whom. *You pay the full $30 bill from your bank, but only $10 is your share* Asset:Bank -$30 Expense:Utilities $10 Asset:Alice $10 Asset:Bob $10

Re: invoice+bill for same bank transaction for business

2018-01-31 Thread Christopher Lam
Hi Paul We have similar in Australia called 'Recipient Created Tax Invoices' see https://www.ato.gov.au/Business/GST/Issuing-tax-invoices/ I solve this by NOT using the Gnucash business features at all. The agency takes care of all customer payment chasing, refunds, calculating taxes etc,

Re: Can I automate any of this?

2018-02-01 Thread Christopher Lam
Hi Bob: Try this for an unusual solution... https://lists.gnucash.org/pipermail/gnucash-user/2017-February/069016.html C On 31/01/18 15:59, bob_summers wrote: Hi, I've been using GnuCash for a few years in my business, a language academy, and it does everything I need it to, which is;

Re: Future allocated money vs Budgets

2018-02-04 Thread Christopher Lam
Looks nice. My main concern with these "shadow accounts" is that they will, by default, be counted in the Net worth reports, income reports, etc, and must be manually deselected every time. In my view budget allocations are technically "outside the books" and must therefore ideally be recorded in

Re: can i use to handle VAT?

2018-02-04 Thread Christopher Lam
Hi Joanna This is not a daft question. It is answered in https://wiki.gnucash.org/wiki/FAQ#Tax_Handling:_Goods_and_Service_Tax_.28GST.29_or_Value_Added_Tax_.28VAT.29 The exact process may vary, but ultimately these VAT amounts must be recorded in accounts of type asset or liability.

Re: Trading Accounts

2018-02-12 Thread Christopher Lam
Hi Les Really interesting question, with a simple and a complicated answer. Simple answer: I think Trial Balance would differ if you deal with multiple currencies or stock (i.e. multiple conversions with differing dates and prices). Complicated answer:

Re: Split Transaction To Personal And Business

2018-01-02 Thread Christopher Lam
Well within the regular register there's no mechanism for inputting, e.g. $40 electricity paid and have the system allocate among splits according to a formula. There's however a mechanism for inputting in a Scheduled Transaction (known as SX), e.g. let's say 50% use is personal and 50% is

Re: Close Year

2018-01-03 Thread Christopher Lam
You can 'close the year' with Tools > Close Year which adds a 'Closing entry' transaction from Expense and Income accounts on a specific date to the Equity account. The benefit is that the Income & Expense balances will reflect 'balance this year' so far. It doesn't however prevent modification of

Re: [GNC] Fwd: The two modules

2018-06-22 Thread Christopher Lam
o parity, the stock might crash, and the housing market could implode. So, we may need input from others who might have a different viewpoint. Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 ----------- GnuPG Fingerprint: 8A25 9726 D43

Re: [GNC] few questions on gnucash

2018-08-05 Thread Christopher Lam
Depending on how the sales taxes are recorded, the "Income & GST report" may be able to show sales/income and their taxes. On Mon, 6 Aug 2018, 09:30 David Cousens wrote: > Julie > > GnuCash is primarily a double entry accounting system. It is used world > wide > so its functions are usually

Re: [GNC] Reconciliation Report

2018-08-10 Thread Christopher Lam
Which version? There was a change in date strategy for reconciliation report in the past couple releases. Would you mind attaching a screenshot? If you need to hide sensitive data, any paint program such as MSPaint can hide data. Please switch option "General / Add options summary" to

Re: [GNC] Reconciliation Report

2018-08-10 Thread Christopher Lam
The reconcile report 'date' selection applies to the 'reconcile date', so any reconciled transaction whose reconcile-date falls between start-date and end-date is included. I think this behaviour applies from 3.2 onwards. Any unreconciled transactions are also included. The reasoning was that

Re: [GNC] transaction report missing subtotals

2018-08-09 Thread Christopher Lam
Can you attach a screenshot of the problem? Use MSPaint or something to hide any sensitive data. Also switch on "General / Add options summary" to "Always" to show us which options were set. On Wed, 8 Aug 2018, 20:08 lebyarules via gnucash-user < gnucash-user@gnucash.org> wrote: > hi all > >

Re: [GNC] Production of UK VAT reports

2018-08-11 Thread Christopher Lam
The simple answer is there is no 'VAT-done' flag. You'd either book the VAT-able transaction using posted-date, or not... If a transaction is booked in error and already processed/reported to authorities, then do another reversing transaction (IMHO; if the accountant agrees) at a later date.

Re: [GNC] Links in transaction reports

2018-08-16 Thread Christopher Lam
Hi Nancy, welcome to Gnucash user list! You can disable links but it's not obvious in the transaction report. You'll need to modify the style sheet used (edit menu) then reload the transaction report. On Thu, 16 Aug 2018, 16:55 Nancy Tague wrote: > I’m a brand new GnuCash user trying to figure

Re: [GNC] Links in transaction reports

2018-08-16 Thread Christopher Lam
ckable option in another seems capricious. > > David T. > > > On Aug 16, 2018, at 3:07 AM, Christopher Lam > wrote: > > > > Hi Nancy, welcome to Gnucash user list! > > > > You can disable links but it's not obvious in the transaction report. > > You'll n

Re: [GNC] Links in transaction reports

2018-08-17 Thread Christopher Lam
for you. > > David T. > > On Aug 16, 2018, at 8:31 PM, Christopher Lam > wrote: > > Um. It's historical. And nobody has requested removing links in amounts > loudly enough to warrant an incompatible change of options. If there is > demand, in which tab sho

Re: [GNC] Help with Reports Please!

2018-08-12 Thread Christopher Lam
try Transaction Report * accounts / accounts - choose income+expense accts * display / subtotal-table - enabled * sorting / primary-key - account name * sorting / primary-subtotal - enabled * sorting / secondary-key - date * sorting / secondary subtotal - monthly if the subtotals are not

Re: [GNC] Trial Balance report error

2018-08-14 Thread Christopher Lam
https://bugs.gnucash.org/show_bug.cgi?id=796696 Known bug, fixed for next release. This bug report has instructions for fixing in interim. On Tue, 14 Aug 2018, 19:52 James Thorpe wrote: > Dear List > > I just upgraded to the latest version on Windows (3.2) and now it seems > the Trial Balance

Re: [GNC] Balsheet-eg.scm problem

2018-08-23 Thread Christopher Lam
I can confirm loading of eguile reports is different. Hence I could not trigger loading. Hence there's no test for them. Off they go, please! On Thu, 23 Aug 2018, 21:20 Derek Atkins wrote: > Hi, > > "Stephen M. Butler" writes: > > > I tripped over a few more typos that seemingly were

Re: [GNC] Veihicle mileage cost such in HomeBank?

2018-08-27 Thread Christopher Lam
My solution is to have an Expenses:Mileage account, with an unused/obsolete currency, and change its symbol to "km". I only record business mileage, i.e. description: "travel to client in next town", dated 01/05/2018 * Expenses:Business:Mileage +40km * Equity:Mileage -40km Thus my annual

Re: [GNC] Reports indentation

2018-07-20 Thread Christopher Lam
Hi Nigel Please feel free to help beta test a new income-statement. It aims to replace the current one which has numerous unfixable inconsistencies. It has no redundant subtotals, and it can compare incomes/expenses across periods. The account indenting is better, and the amount indenting

Re: [GNC] balance sheet and account equation for Business Accounts

2018-07-22 Thread Christopher Lam
Unfortunately the current balance sheet will compulsorily convert all amounts to a target currency. If you're willing to help beta test, a new balsheet is in development at https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm

Re: [GNC] Invoices - Extra Notes missing

2018-07-21 Thread Christopher Lam
The "Australian Tax Invoice" eguile report on my end does seem to use the Extra notes option. Perhaps you'd be keen to try the beta invoice engine? It upgrades the "Printable Invoice" to have a much more customisable layout and can use CSS. https://github.com/Gnucash/gnucash/pull/357 On

Re: [GNC] balance sheet and account equation for Business Accounts

2018-07-22 Thread Christopher Lam
Don't need to be a programmer. Just save the link into the standard-reports folder - on windows it's somewhere in c:\program files (x86)\gnucash On Mon, 23 Jul 2018, 02:20 nor via gnucash-user wrote: > That will be great. Link viewed. However, I am not comfortable with > programmingnor > > > >

Re: [GNC] Why duplicate reports in 3.2?

2018-07-13 Thread Christopher Lam
On 13/07/18 05:17, David T. via gnucash-user wrote: As I understand it, the two menu items call the same report file with different title flags, so there is no overhead in storage or codebase. Your concern boils down to the fact that both names appear in the menu. While this is annoying, it

Re: Where does Gnucash keep the list of accounts to match transactions to when importing OFX/QFX

2018-01-22 Thread Christopher Lam
Hi Clint, the associations are kept within the datafile itself. There's no current mechanism for modifying these associations, however, the upcoming version 3.0 will feature an editor. On 23 Jan 2018 11:16 AM, "Clint Redwood" wrote: > Hi, > > I'm importing a number of

Re: [GNC] Additional filter option (by number) for Transaction report

2018-04-10 Thread Christopher Lam
To Whistler and Amish: /If you have upgraded to Gnucash 2.7 onwards:/ To Whistler: See attached patch - you can apply to your sources and rebuild, or patch transaction.scm in gnucash installation folder. To Amish: You can set Filter/Transaction Filter regex option to true, and use POSIX

Re: GnuCash 3.0 initial observations

2018-04-05 Thread Christopher Lam
Hi Deva First you forgot to attach screenshots. I'll assist where I can: On 05/04/18 16:43, Deva - wrote: Hello, Firstly, thank you all for this new and much awaited version. I have just installed GC 3.0 on Mac OS High Sierra 10.13.4 and have been browsing through what’s new and what’s

Re: Unrealized loss

2018-04-04 Thread Christopher Lam
Hi Alain, please report bug and we can track discussion there. On Wed, 4 Apr 2018, 20:12 wrote: > I suspect there is a bug that should be reported: > > As I do NOT manage currencies other than EUR and no traders accounts > taking into account share values, I have deleted all

Re: GNUCash 3.0: Report Printing problems

2018-04-04 Thread Christopher Lam
Hi Steve 2-4 can be easily solved by File > Export > Export Report to file, and opening the file in a modern web browser for printing. The report generation code exports to HTML natively, but is limited by the webkit implementation used. A modern web browser will obey the html rules better.

Re: [GNC] GnuCash 2.6.20 Report Problem

2018-04-15 Thread Christopher Lam
Hmm sounds like Windows versions come with guile-1.8. The following change should fix this. Change line 271-272 in category-barchart.scm to: (define the-acount-destination-alist   (account-destination-alist accounts account-types   (if (equal? account-levels 'all)      

Re: [GNC] Quicken running balances - available in GnuCash??

2018-04-22 Thread Christopher Lam
The Transaction Report options window is probably too small. Use mouse-wheel to scroll down, or expand the options window. HTH On 23/04/18 08:25, Billsy wrote: Thankyou for the tip - I am not able to locate the Display/Running Balance = enabled parameter in reports. Can you advise? Thanks

Re: Unrealized loss

2018-04-01 Thread Christopher Lam
Salut Alain You will also incur unrealized gains/losses upon currency transfers, eg EUR->GBP->EUR whereby exchange rates are fluid. HTH On 01/04/18 18:17, cag...@free.fr wrote: De: "John Ralls" À: cag...@free.fr Cc: gnucash-user@gnucash.org Envoyé: Dimanche 1 Avril

Re: "Unrealized Losses" in Trial Balance Report

2018-03-22 Thread Christopher Lam
Hi Richard If I understand 'unrealised gains', this is a known issue. I think any double-entry accounting system will have this issue when currencies or stocks are converted without accounting for capital gains. With stocks we expect to receive capital gains and are usually taxed on these

Re: Compiling -DWITH_GNUCASH=NO

2018-03-22 Thread Christopher Lam
Hi Potuz This is clever- would you mind documenting the process to run reports from command line? C On 23/03/18 04:57, Potuz wrote: On Mar 22, Potuz wrote: Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run

Re: Confused by "Reverse"

2018-02-25 Thread Christopher Lam
Hi Stan, You are right, reports are not always consistent in offering consistent nor flexible options. They have been growing organically for nearly 2 decades now, with no overriding benevolent dictator, and many cooks had had a hand in developing them. The most flexible by far will always

Re: [GNC] Fwd: The two modules

2018-06-29 Thread Christopher Lam
Hi David It'd seem the Frozen status relates to transaction status (Unreconciled/Cleared/Reconciled/Void/Frozen) only, and is so far unused. I'm going to amend the balsheet-pnl to the desired format. This means the accounts are shown sequentially, and *every* account will also include

Re: [GNC] Forward payments

2018-06-28 Thread Christopher Lam
You are effectively doing a split transaction. Assets:Bank -$1250 Assets:Staff  +$250 (sundries) Expenses:Staff +$1000 (salary) As the staff member spends appropriately, transfer from Assets:Staff to Expenses:Various C On 28/06/18 18:31, Tony Vanson wrote: Thank you for your patience Yes,

Re: [GNC] Fwd: The two modules

2018-06-28 Thread Christopher Lam
Hi Dave It's nice to have input from someone in the know. I have used the placeholder flag to tag accounts which are now closed, e.g. closed bank accounts, loans paid off, old unused expense categories. This is not expressly disallowed by the UI, and the advantage here is the account does

Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income Statement (Multi-Column)

2018-10-13 Thread Christopher Lam
of the report should give me what I am looking for, with a little > adjustment in thought process. > > Cheers. > > On 12-Oct-2018, at 8:46 PM, gnucash-user-requ...@gnucash.org gnucash-user-requ...@gnucash.org> wrote: > > Date: Fri, 12 Oct 2018 22:04:40 +0800 > From: Christop

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-10-21 Thread Christopher Lam
It's hard wired because that's what the report writer wrote, and was merged into gnucash, as a voluntary contribution. It's rather difficult to modify these reports and maintain full compatibility with everyone who has used them previously and expect the report output to be predictable. Often

  1   2   3   4   5   6   >