Re: [GNC] Net Worth Barchart
On Tue, 6 Dec 2022 00:57:44 -0600 Adrien Monteleone wrote: > Liz, > > I just ran the chart for myself and indeed, it appears your > Liabilities are backwards. That is, if you owe money, they should > have a Credit balance, but yours show as Debit balance. (The *normal* > balance of a Liability account is Credit, not Debit) > > What is your preference setting for Accounts > Reversed Balanced > Accounts? > > If it is "none" or "Income & Expense" then your Liability accounts > will show as negative amounts in the Accounts tab if they are a > Credit balance. > > If it is "Credit accounts" then they will show as positive on the CoA. > > If your balances are opposite of that, then your balances are > reversed. (they are 'contra balances' from what is normally expected) > > - > > As to your specific situational question: > > I'm not real clear on your SX template. Can you provide it for > clarification? (no need for amounts, It's just to clear up which > splits you have as Debits & Credits) > > From what I gather, this is a transaction to record money you pay as > wages (to yourself or others), the liability for taxes on those > wages, and super (??) payments. (not sure what that last part is) > > I'm not quite understanding why that is all in one transaction. But > I'll take a guess, maybe my below examples will be roughly correct... > > > > 1. Payments of wages by a company to employees would simplistically > be something like: > > Dr. Expenses:Labor >Cr. Cash > > > > 2. A (likely) separate transaction would record payroll tax liability > such as: > > Dr. Expenses:Payroll Taxes >Cr. Liabilities:Payroll Taxes Due > > (arguably, you can put this all in one transaction) > > > > 3. Then when you make the actual payment: > > Dr. Liabilities:Payroll Taxes Due >Cr. Cash > > Which reduces the previous liability incurred and recorded, by the > amount of your payment. > > You'd repeat that second transaction for any adjustments you are > advised to make as you note, and then zero it out with another > payment. (or otherwise your 4th Quarter payment is simply larger) > > - > > If the situation is concerning something like a 'self-employed' > status and you're making quarterly estimated income tax payments, the > treatment would generally be similar, just different terminology > and/or account names. > > - > > Now, in the case (which it appears you are dealing with) that you are > paying that tax liability at the same time as wages are disbursed, > the treatment is similar save that you can record the payment all at > once and *maybe* skip the intermediary step of 'Taxes Due' splits: > > Dr. Expenses:Labor > Dr. Expenses:Payroll Taxes >Cr. Cash > > You would still record the Liability of Taxes Due when you are > provided the adjustment you need to make, and then zero it out with > the final payment. > > However, I'd bet good practice would be to record those Liability > splits regardless, just to show a trail that they were incurred, and > then covered, thus: > > Dr. Expenses:Labor100 > Dr. Liabilities:Payroll Taxes Due 10 > Dr. Expenses:Payroll Taxes 10 >Cr. Liabilities:Payroll Taxes Due 10 >Cr. Cash 110 > > (the Credit to Cash being equal to the first two Debits and splits 3 > & 4 must be also equal to each other) > > *Hopefully* the three middle splits are all equal, but if the > Liability as estimated is not fully paid for, or overpaid, the Debit > to the 'Due' account (split #2) would be less or more accordingly. > > > Regards, > Adrien > > p.s.—that's how it would look on paper! > Thanks Adrien No I didn't have any reversed balance accounts set and it wasn't the Payroll tax, that was OK. 'Super' is the standard way of pronouncing 'Superannuation' here, and that is retirement savings in plain English. The image is the three monthly accounting for GST and company tax prepayment (PAYG) and the monthly payroll tax payment. Liabilities: Tax Liabilities is the same value as Expenses: Salaries : tax payments Expenses:Company Tax is after Geoff put me straight Part of my problem was calling everything "Tax" instead of being more specific. Now if I rename the Expenses:Salaries:Tax payments to Ex:S:Payroll Tax that could help the next lot of confusion. For those who wonder why I have so many blanks in a scheduled transaction, every three months I do some computation to fill in the blanks. A prepared template means I don't miss any and claim everything they owe me. Liz ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Same security, two namespaces
On 2022-12-05 22:17, Adrien Monteleone wrote: > If you are searching for Accounts and not Transactions use Edit > Find > Account. Or, click into the list of account names and begin typing the name of the one you're looking for. I've found that a huge timesaver versus scrolling through a long list. (And anyway, my version of GC doesn't have Edit » Find Account.) Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Net Worth Barchart
Hi Liz; I guess we should do similar activities in tracking GSTs, except I don't handle company tax. I have an account structure: GST GST:GST Sales [L] GST:GST Purchases [A] GST:GST BAS [A] My sales are recorded as: Income:Sales -$1000 GST:GST-Sales -$100 Asset:Bank +$1100 My purchases are recorded as: Expenses:Purchase +$200 GST:GST-Purchase +$20 Asset:Bank -$220 Every end-quarter I'll transfer the balance of [GST Sales] and [GST Purchases] into [GST BAS], so that GST Sales & Purchase now have a balance of zero. 30/09/12 Accumulated GST on Sales GST:GST Sales +$2,345.67 GST:GST BAS -$2,345.67 30/09/12 Accumulated GST on Purchases GST:GST Purchases -$2,000 GST:GST BAS +$2,000 The [GST BAS] account will then be settled via ATO transfer. 30/10/12 ATO BAS and PAYG GST:GST BAS -$345.67 Expenses:Income Tax +$(TOO_MUCH + 345) Asset:Bank -$TOO_MUCH and because the ATO doesn't care about GST cents, I create a rounding transfer: 30/09/12 GST Rounding GST:GST BAS +$0.67 Equity:Rounding -$0.67 As a result, all these GST accounts are regularly reset to zero, and the equity rounding account hovers around zero. On Tue, 6 Dec 2022 at 16:56, Liz wrote: > On Tue, 6 Dec 2022 00:57:44 -0600 > Adrien Monteleone wrote: > > > Liz, > > > > I just ran the chart for myself and indeed, it appears your > > Liabilities are backwards. That is, if you owe money, they should > > have a Credit balance, but yours show as Debit balance. (The *normal* > > balance of a Liability account is Credit, not Debit) > > > > What is your preference setting for Accounts > Reversed Balanced > > Accounts? > > > > If it is "none" or "Income & Expense" then your Liability accounts > > will show as negative amounts in the Accounts tab if they are a > > Credit balance. > > > > If it is "Credit accounts" then they will show as positive on the CoA. > > > > If your balances are opposite of that, then your balances are > > reversed. (they are 'contra balances' from what is normally expected) > > > ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Colum headers missing on all accounts
Am 04.12.22 um 22:06 schrieb Scott Traurig:
I was rearranging the sizes of the columns in one of the account ledgers
and now both the Transfer and Reconcile ("R") column labels are gone.
They are only visible, if the cursor is in a split÷check your view mode,
too. The main line of a transaction has no fields there.
HTH
Frank
___
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 replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Same security, two namespaces
Edit -> Find Account works fine for finding 'KOF' and 'coca coca' somewhere in the account name. However, 'Accounts' is the only tab showing on my screen, I click on that tab, and type 'KOF', I get a small window in the bottom right corner of the screen -- but NO list of accounts. Also, typing 'coca' also gets NO list of accounts. In case it matters, the only accounts listed on my screen when I do the Finds are: Assets, Equity, Expenses, Income, Liabilities, and Trading. I have also tried clicking on Assets and typing KOF Still nothing. On Tue, Dec 6, 2022 at 8:08 AM Stan Brown wrote: > On 2022-12-05 22:17, Adrien Monteleone wrote: > > If you are searching for Accounts and not Transactions use Edit > Find > > Account. > > Or, click into the list of account names and begin typing the name of > the one you're looking for. I've found that a huge timesaver versus > scrolling through a long list. > > (And anyway, my version of GC doesn't have Edit » Find Account.) > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > > ___ > 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 replies. > You can do this by using Reply-To-List or Reply-All. > ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stock spinoff
I usually Google search out the OCC Memo on the split or spinoff, as it does a precise analysis of the basis. (OCC Options Clearing Corp manages stock option contracts traded on Options markets). ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Net Worth Barchart
Thanks for the clarification. I think you're on the right track now. Regards, Adrien On 12/6/22 2:55 AM, Liz wrote: Thanks Adrien No I didn't have any reversed balance accounts set and it wasn't the Payroll tax, that was OK. 'Super' is the standard way of pronouncing 'Superannuation' here, and that is retirement savings in plain English. The image is the three monthly accounting for GST and company tax prepayment (PAYG) and the monthly payroll tax payment. Liabilities: Tax Liabilities is the same value as Expenses: Salaries : tax payments Expenses:Company Tax is after Geoff put me straight Part of my problem was calling everything "Tax" instead of being more specific. Now if I rename the Expenses:Salaries:Tax payments to Ex:S:Payroll Tax that could help the next lot of confusion. For those who wonder why I have so many blanks in a scheduled transaction, every three months I do some computation to fill in the blanks. A prepared template means I don't miss any and claim everything they owe me. ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stock transfer
Why not do what they do? If they do a direct transfer or rollover, I think you should try to mimic their behavior. Clearly, if they send you the proceeds, that is just like selling the Vanguard shares and buying new ones in Fidelity. If it is a direct rollover, you could enter each transaction, which could be tedious if there are years of reinvested dividends or additional purchases. On Mon, Dec 5, 2022 at 3:23 PM Fred J. Tydeman wrote: > What is the best way to transfer stock from one brokerage to another > brokerage? > For example, 100 shares IBM from Vanguard to Fidelity. > > Enter just the number of shares and leave the price and cost fields blank? > Enter number of shares along with basis price of those shares? > Something else? > > What about if there are multiple purchases/sells in the old account? > How would lots be done in the future? > > > --- > Fred J. TydemanTydeman Consulting > tyde...@tybor.com Testing, numerics, programming > +1 (702) 608-6093 Vice-chair of PL22.11 (ANSI "C") > Sample C99+FPCE tests: http://www.tybor.com > Savers sleep well, investors eat well, spenders work forever. > ___ > 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 replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Same security, two namespaces
The method Stan described only works for 'visible' text in that tab. Thus, you need to have the entire chart expanded. (or at least the portion where those accounts exist) Regards, Adrien On 12/6/22 9:06 AM, Fred Tydeman wrote: Edit -> Find Account works fine for finding 'KOF' and 'coca coca' somewhere in the account name. However, 'Accounts' is the only tab showing on my screen, I click on that tab, and type 'KOF', I get a small window in the bottom right corner of the screen -- but NO list of accounts. Also, typing 'coca' also gets NO list of accounts. In case it matters, the only accounts listed on my screen when I do the Finds are: Assets, Equity, Expenses, Income, Liabilities, and Trading. I have also tried clicking on Assets and typing KOF Still nothing. ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Same security, two namespaces
I thought that has been around since the 2.6.x days. (many years now) Regards, Adrien On 12/6/22 7:07 AM, Stan Brown wrote: (And anyway, my version of GC doesn't have Edit » Find Account.) ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] searching for inventory tags -- bind keys -- best ways
*might* You are editing line items on an invoice. What happens when you try to later view that invoice? It might magically work. It might blow up. The only 'supported' method of editing invoices is to unpost, edit, repost. Otherwise, best of luck and keep your fingers crossed. Regards, Adrien On 12/5/22 11:13 AM, John Griessen wrote: On 12/4/22 22:27, Adrien Monteleone wrote: Any changes you make otherwise might cause havoc. Changes to memo lines will cause havoc? Why -- no numbers in transactions are changed by memo lines. ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] searching for inventory tags -- bind keys -- best ways
I was fairly certain they were immutable, and indeed, at least in 4.12, they are. (if you have a different version and they are, that is a bug) You can't edit memos of splits for posted bills (AP) or invoices (AR). If they are unposted, they don't appear in the respective registers. Note, I'm speaking of line items on bills/invoices entered using the Business Features, *not* manually entered transactions. Those are of course editable. But be warned, if you also use the Business Features, they cannot 'see' any manually entered transactions. Regards, Adrien On 12/4/22 2:48 PM, John Griessen wrote: PS: since posing these questions, I've looked more at memo lines and find that AR payment memo lines *ARE* editable. So now I will be adding my inventory tags to those AR memo lines when doing a payment , or after! ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report month end values
Is there a way to get the month end value of a specific account for several months? Each month should be on its own line. ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Crash in Net worth linechart
I am trying to do a Net Worth Linechart for one account (with two investments) in COP (Colombia Pesos). This is what I get: Report error An error occurred while running the report. 11 (apply-smob/1 #) In options.scm: 2037:10 10 (run-callbacks) In srfi/srfi-1.scm: 640:9 9 (for-each # …) In unknown file: 8 (gncp-option-invoke-callback # …) In c-interface.scm: 35:4 7 (gnc:call-with-error-handling _ _) In ice-9/boot-9.scm: 829:9 6 (catch _ _ # …) In c-interface.scm: 39:40 5 (_) In report-core.scm: 752:25 4 (gnc:report-render-html #< type: "d8b63264186b11e19038…> …) In standard/net-charts.scm: 316:30 3 (net-renderer #< type: "d8b63264186b11e190380015582913…> …) 233:6 2 (process-datelist _ _ _) In srfi/srfi-1.scm: 466:18 1 (fold # …) In standard/net-charts.scm: 235:9 0 (_ _ 0) In procedure +: Wrong type: #f However, if I change Price Source from Weighted Average to Closest to report date, I get no crash and a plot. If I do the same report, but with a different Colombia brokerage account, it works just fine. Each of the two Colombia brokerage accounts holds one money market account and one COP account. If I look at the Price database, they both have reasonable prices; nothing looks bad there. Aside: If I enable Show table in the Display Options, I can get the month end values for each month in question, with each month on its own line. ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report month end values
> On Dec 6, 2022, at 12:37 PM, Fred Tydeman wrote: > > Is there a way to get the month end value of a specific account for several > months? > Each month should be on its own line. Use the chart for the account type, e.g. Reports>Assets & Liabilities>Asset Chart. In report options select the account you want in the accounts tab, turn on show table in the display tab, and set your date range and interval on the general tab. When it displays the table will be underneath the chart and you can paste it into a spreadsheet for further manipulation. Regards, John Ralls ___ 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 replies. You can do this by using Reply-To-List or Reply-All.
