Re: [GNC] Linux. Mysql and Gnucash 4.1

It offers 4 backends: XML (default) SQLite MySQL/MariaDB PostgreSQL You have to install the desired backend libs in most cases to be offered the option of using it. The default requires no special effort. Many Linux distros also come with SQLite support by default, so mileage varies.

Re: [GNC] File browser file type filter and bookmarks

The File menu has a 'recent files' list at the bottom. That gets populated on each File > Open of a different file. (or the same file in a different location) You only need to do File > Open once per file, and then afterwards, just select it from the list. GnuCash remembers where it saved it,

Re: [GNC] REPORT CONFIGURATION

You can define (add) style sheets for each special instance and tie them to a saved configuration. You can also achieve some of the same results using the General Tab of most reports with or without involving saved configurations. (thus the rest of the style sheet stays the same) You can

Re: [GNC] Scheduled transactions feature or bug?

I agree, the behavior should not be changed, but perhaps the UI could be improved if people aren't realizing what is going on. Of course, there is a responsibility for the user to learn the software, how it works, and pay attention to things. (such as noticing last run and next occurrence

Re: [GNC] Can't find the file sometimes

That would tell me you moved the file using Finder. You can say 'yes' to remove it from the list if you like. When you choose File > Open and find its new location, GnuCash will add it back to the list with the new path. If you move data files, GnuCash will give you this message. If you want

Re: [GNC] Scheduled transactions feature or bug?

This sounds like a good case of not auto-creating them, but rather approving them each time. There are options for this. Regards, Adrien On 4/12/22 9:55 AM, Dale Alspach wrote: I had a scheduled transfer to savings that I disabled for a few months. When I re-enabled the scheduled transfer I

Re: [GNC] Auto-save failure

In Preferences > General there are some Auto-Save options. If those are set correctly, then something else is amiss. Unfortunately, if you've already re-started GnuCash, the Tracefile was overwritten, so if there is info there to help, it is gone. I take note you're using the Flatpak. This

Re: [GNC] Reconciliation discrepancies

Do you by chance have sub-accounts at play, and are you including them in the reconcile? Sub-accounts *shouldn't* matter because 'if done correctly' they shouldn't affect the parent balance, and serve just as a segregation/classification tool. But the caveat is that transactions there might be

Re: [GNC] Debit and Credit columns wrong way round on one transaction report but not the other

If indeed your transactions were entered backwards, you can go through each one and put a minus sign in front of each and every debit and credit amount and they will swap sides after tabbing through. (there might be an easier way to swap them, but I'm not aware of such) There's no such thing

Re: [GNC] Debit and Credit columns wrong way round on one transaction report but not the other

I suspect you have way more accounts than just 2! (seriously, read the manual) What do you mean by "wrong way 'round"? Debit is always the left-hand column, Credit is always the right-hand column. They never swap. Your *data* might be swapped though. (you've entered debits instead of

Re: [GNC] creating a Tranaction report

hat but can not find it. Does Anyone know what the sequence is? Chuck On Wed, Apr 6, 2022 at 2:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I'm not 100% certain what specifically you are asking for, but if you want to save a particular report configuration (such as after

Re: [GNC] creating a Tranaction report

I'm not 100% certain what specifically you are asking for, but if you want to save a particular report configuration (such as after selecting desired accounts) you can do that from the Reports menu. At the bottom are three options: 1. Saved Report Configurations - brings up a list of

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu - solved

I think that was the 'high bit characters' Jeff was referring to. Since they were in the path, most definitely, that was the problem with opening the file. (still not sure why that would make the icon fail) How they got there is anyone's guess, maybe a bad copy/paste? Glad to hear it is

Re: [GNC] Loss one of my file

For completeness and clarity, this is only an issue (so far as I know) with *GnuCash* on MacOS. It is not generally a MacOS problem. I have often double-clicked other files which resulted in them being opened in their proper app. Regards, Adrien

Re: [GNC] Loss one of my file

Yes, sorry Stan, since the OP was on a Mac I was replying for just that case. I should have made the caveat more specific. Frank kindly did so for posterity. Regards, Adrien On 4/1/22 9:51 AM, Stan Brown wrote: On 2022-03-31 16:05, Adrien Monteleone wrote: You can't double-click the file

Re: [GNC] Stock pricing

John, That definitely doesn't sound right with the download. Are you letting Sourceforge auto-download for you? Try the direct link: https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.10/gnucash-4.10-1.setup.exe/download You can get to that on your own if you want by

Re: [GNC] creating a Tranaction report

As for 'help' go to gnucash.org, left hand menu, you find 'Documentation', 'FAQ', and 'Wiki' links. 'Documentation' offers a 'Help Guide' and a 'Tutorial & Concepts Guide'. The Help Guide is geared more toward screen/UI explanations, key combos, etc. The Tutorial & Concepts Guide is about

Re: [GNC] Loss one of my file

You can't double-click the file to open it, if that is what you are doing. GnuCash will always open the last used file. Use File > Open > and then navigate to where file #2 is and open it. Afterwards, both should appear in your 'recent file list' at the bottom of the File Menu. Always start

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

Ha! Best of luck with the keyboard! Check into (Ubuntu) Settings > Universal Access > Typing > Screen Keyboard. This will pop-up an on-screen keyboard when a typing field has focus. That's not the best workaround, but it will help a bit. - As for GnuCash, what about the USB access info

Re: [GNC] Customizing invoices (Helmut Eller

John, Sorry I guess I misunderstood your suggestion wrong. What's throwing me off is that setting up a non-currency commodity isn't going to help as I see it. Quantity is not a commodity. It is the multiplier of one. A line-item on an invoice is always some multiplier of a currency. The

Re: [GNC] Customizing invoices (Helmut Eller

Helmut, It isn't a matter of using securities on invoices. The Security Editor is simply where you set the smallest fraction of a currency. (and thus the number of digits displayed) John is proposing tying that setting in to be used outside of securities, in this case for invoices amounts.

Re: [GNC] creating a Tranaction report

Try: Accounts > Filter Type > "Do not do any filtering" and un-select every account in that part of the dialog. (the top section should have the desired accounts selected, 'All' is fine of course) Did you get a report? Then try: General > Add Options Summary > "If no transactions matched"

Re: [GNC] Customizing invoices (Helmut Eller

Thanks to you and Chris for investigating. Hopefully, this will resolve the discrepancy. Regards, Adrien On 3/29/22 10:50 PM, john wrote: Chris has created https://bugs.gnucash.org/show_bug.cgi?id=798496 to document working on that.

Re: [GNC] how to put loan downpayments in budgets

Perhaps my wording was poor. Yes, I see it the same way. (hence my comment about envelope method budgeting) Regards, Adrien On 3/29/22 10:43 PM, john wrote: I think you're conflating two separate things. Saving up for a down payment is not buying a house. There's no property value to

Re: [GNC] Customizing invoices (Helmut Eller

On 3/29/22 5:14 PM, John Ralls wrote: On Mar 29, 2022, at 10:33 AM, Adrien Monteleone wrote: The report should simply print the data from the invoice unchanged. Be careful what you ask for. The data from the invoice is a rational number, meaning a numerator and a denominator. The print

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

For the icon issue, while Flatpak apps are sandboxed and might not have access to that icon location, have you tried copying it to somewhere in your home folder and seeing if that works? (it is the Desktop file using it, so this would be weird, but I guess worth a shot)

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

The 'no suitable backend' is clueing me to an issue with that particular file and not having the right backend installed/enabled. But Jeffrey already said opening the file directly works fine and is using XML. (usually one sees that error when trying to use one of the db backends since XML is

Re: [GNC] how to put loan downpayments in budgets

Tough one. The property value doesn't increase because you didn't borrow the full price and paid cash up front for a portion of it. The liability doesn't change because that's after (net) the down-payment. I'd hazard either an asset or equity account for something like 'savings goals'

Re: [GNC] Customizing invoices (Helmut Eller

David, it seems the list-thread is broken, so for completeness, I'm posting there that I filed bug: https://bugs.gnucash.org/show_bug.cgi?id=798493 on this issue. This also happens for the Unit Price column. The report should simply print the data from the invoice unchanged. Regards, Adrien

Re: [GNC] Customizing invoices

Helmut, I just filed bug: https://bugs.gnucash.org/show_bug.cgi?id=798493 This is also a problem with the Unit Price field. The invoice itself contains the desired precision as you noted, but the Report alters it. Rather than a preference or option to edit the report directly (a Herculean

Re: [GNC] Report - Income Statement - Layout problem

And there is always the Flatpak. So if you aren't comfortable with building, it is a bit easier to install. Since freeze on Ubuntu 22.04 Jammy has already happened (release targeted to 4/21/22), I doubt it will include GnuCash 4.10, lucky if it is 4.9. You *might* be able to get a special

Re: [GNC] gnucash-user Digest, Vol 228, Issue 46

Eric, First, as a matter of 'safe', I'd always edit a transaction from the non-AR/AP account, that is, from your cash, check, et cetera account where the funds originated/ended-up. You *can* edit transactions in AR/AP, but you have to be careful about doing so. Chris' suggestion to use the

Re: [GNC] Report - Income Statement - Layout problem

Carl-Kensaku, It looks like the fix has been implemented for v4.10 due out tomorrow. I just finished testing Chris's fix and so far it seems to do the trick. Your P/Income Statements should line up now regardless of the account depth or the length of account names. Regards, Adrien On

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

I think David Whiting's reply should get you there. (I didn't notice it when I sent mine) If that doesn't work, report back what happens instead. Regards, Adrien On 3/25/22 6:24 PM, Jeff wrote: I would like to have individual icons that execute GNC for a specific set of books. IE: icon

Re: [GNC] change default behavior of ctrl-PgDn

Actions > Blank Transaction has cmd-pgdn as the key combo. I'd hazard it is ctrl-pgdn other than Mac. I recall now one of your replies in a previous thread or maybe a bug about this. And indeed shift-pgdn does bring you to the Blank Transaction with focus on the date field. But the one listed

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

You want an application icon or for the individual data files (books)? The application is a bit of work if it is Flatpak, but I would think the data files should be no issue. Regards, Adrien On 3/25/22 2:38 AM, Jeff wrote: I have never had a problem creating desktop icons for multiple books

Re: [GNC] change default behavior of ctrl-PgDn

Indeed, shift-fn-down_arrow drops me to a blank transaction with the focus on the date field. Thanks! I still think it a bug that the official key combo doesn't work properly. I thought one was filed already but can't seem to find it. Note, it isn't just the key combo not working. Using

Re: [GNC] change default behavior of ctrl-PgDn

I don't think the date itself is relevant. What you want is to get to a new blank transaction, correct? I have the same problem using 4.9 on MacOS BigSur. I'm not sure when this started. As far as I know, there is no preference. There is a preference for using the 'Enter' key for this

Re: [GNC] Unable to obtain Price data

Les, Could be. I was having trouble with a freeze condition trying to Get Quotes two days ago. Sometimes gnc-fq-dump would return 'unknown' for currencies. Then it would work, then it wouldn't. (GnuCash would always freeze though) I just tried gnc-fq-dump again for several currencies and it

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

. If nothing works, consider possibly using RDP or VNC to your 64bit machine rather than a local install. Regards, Adrien On 3/24/22 8:00 PM, Adrien Monteleone wrote: Jonathan, You should be able to build a current version of Gnucash on your 32bit machine. See the instructions here: https

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

Jonathan, You should be able to build a current version of Gnucash on your 32bit machine. See the instructions here: https://wiki.gnucash.org/wiki/Building And you can update to current on your 64bit machine to match. You might also be able to use the Flatpak if you don't want to build.

Re: [GNC] Report - Income Statement - Layout problem

. Then simply multi-select and apply those styles to the relevant cells. The amount of setup work you need to do just depends on how you want it to look and how often you need to do this. Templates can help here considerably. Regards, Adrien On 3/23/22 12:34 PM, Adrien Monteleone wrote: Carl

Re: [GNC] Report - Income Statement - Layout problem

Carl-Kensaku, No need to dig into Scheme or HTML to fix this. The devs will address it soon enough I'm sure, but this is a 'presentation' issue. That can always be fixed in the short term by either exporting and opening in a spreadsheet, or Select-All & Copy/Paste to a spreadsheet. From

Re: [GNC] How to apply overpayment to new invoice?

If you have both a pre-payment and an invoice unpaid, simply select both of them in the Process Payments window. If the net is zero then they will both be cleared out. If there is still pre-payment left, that remainder will be their next time. If there is still invoice left, it will continue

Re: [GNC] new subaccounts and updating saved reports

Precisely. There's no way to know the user didn't intend to keep the new sub account out of the report. Certainly, the assumption should never be made to automatically include it. The best implementation I can think of would be to check if new accounts have been added since report last run,

Re: [GNC] GNC] Question about Assemblies

On 3/22/22 8:46 AM, davidvernonl...@gmail.com wrote: On your points, of course GnuCash can track costs of inventory in its G/L, but when it comes to recording inventory levels to manage a manufacturing business, quantities are really needed ,either in the system , or in an external system.

Re: [GNC] Report - Income Statement - Layout problem

t expanding something smaller. Regards, Adrien On 3/21/22 9:47 PM, Adrien Monteleone wrote: For me, this only happens at depths 5,6, & ALL. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to uns

Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

It can, you just have to be mindful to make your posting dates (AR and AP) match your payment dates. This requires either delayed posting, (and losing the Due Reminders feature) or un-posting and re-posting as payments are made and received. Regards, Adrien On 3/21/22 4:00 PM, Michael or

Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

Yeah, I got one too. I'm still here of course. I took a break last fall, but have been fairly active since returning. Regards, Adrien On 3/21/22 3:17 PM, David Carlson wrote: Fran_3, I did not see your original message. Did you send it directly to Christopher instead of the list? That is

Re: [GNC] Report - Income Statement - Layout problem

I can reproduce with 4.9 on BigSur. Investigating using Firefox Inspector to view the HTML, I see that there is padding being added to the Expenses section. For me, this only happens at depths 5,6, & ALL. It seems the left hand column where the labels are, is expanding to fit the depth of

Re: [GNC] Report Help

I have some custom reports (not my own, from other users posted on this list) that have worked in 3.x. But they did need some tweaks to get them working in 4.x. This is due to changes in the report system. Also try to reach out on IRC. The devs hang out there (as well as here) and can assist

Re: [GNC] Report Help

The Account Summary is a snapshot, that's why it doesn't let you select a range. (similar to a Balance Sheet) Your other options are an Income Statement/P (which won't show anything but Expense & Income accounts) or perhaps an Equity Statement or the Balance Sheet which includes Equity,

Re: [GNC] How to create Transaction Report Filter on Checking to only show Accounts Payable Transactions?

Fran On the Accounts tab in Options for the report, choose "Filter Type: Include Transactions to/from Filter Accounts" and then in Filter By... choose the Accounts Payable account. You can further refine the results using the Filter tab, to specific Description/Notes/Memo as you are already

Re: [GNC] Question Re: Transaction Report on Expenses, All Children, for 2021

Fran, Do a bit of reading on 'Accrual' vs. 'Cash' accounting. The Business Features of GnuCash are designed for the Accrual method. With a bit of small fuss, they can be used for the Cash method too. Expenses in the Accrual method are 'recognized' when 'incurred'. That is, when you 'owe' the

Re: [GNC] gnucash-user Digest, Vol 228, Issue 33

As I noted in another reply today, if this is just a handful of products, you can likely set up a simple spreadsheet to do the assembly math for you, and then import the result to GnuCash. While spreadsheets aren't part of GnuCash, we can help with how to set that math up, and in a form ready

Re: [GNC] Printing checks

Someone more familiar with printing checks will hopefully chime in, but I seem to recall a recent thread where it was noted that if your Vendor/Employee/Customer 'payee' is already set up with name and address, *and* you try to 'Print Checks' with the existing transaction selected, GnuCash

Re: [GNC] Question about Assemblies

Fred, please be sure to always copy the list address on all replies so the discussion stays on the list. That way, others can benefit from the discussion, as well as chime in and help out. Also keep in mind, we don't give accounting advice here. If you need such advice, you need the

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

As John mentioned, the db name seems incorrect. Did you register the db on MacOS? Error 2026 deals with SSL certificate issues. A web search should provide some guidance. Maybe try without SSL to see if that resolves it? Then you can troubleshoot the SSL problem. - And again, why do

Re: [GNC] Question about Assemblies

If you're looking for 'inventory control/manangement' or 'item tracking' by quantity, no, GnuCash can't do it. (out of the box) Some people have finagled it to do so using user-defined commodity accounts, but that seems like more trouble than it is worth. Inventory management should be done

Re: [GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

You have to install MySQL/MariaDB on MacOS separately as far as I recall. (then save the file in that backend format) But before you go through all of that trouble, what advantages do you think you will gain by using the MySQL backend vs. XML or SQLite? Regards, Adrien On 3/16/22 8:31 PM,

Re: [GNC] IRA/401K income detection

And Stan has now given the breakdown of the splits to accomplish it. That would be followed up with: Dr. Liability:Taxes payable Cr. Checking when they are physically paid. Regards, Adrien On 3/16/22 7:54 PM, D. via gnucash-user wrote: Yeah, I get that an accountant doesn't call this

Re: [GNC] IRA/401K income detection

Good to know, thanks for the clarification. Regards, Adrien On 3/16/22 6:49 PM, D. via gnucash-user wrote: Oh, I know about using the tax flag and TXF report. Done it for years. But unless you figure out how to do what Mike has mentioned (consistently over the years), if you flag these

Re: [GNC] IRA/401K income detection

GnuCash also lets you mark accounts as tax implicated and you can I think tie them to certain 'lines' or certain 'forms'. That's used for personal taxes as well. I wasn't even thinking about the sales tax features for invoices/bills which is something entirely separate. If simply marking

Re: [GNC] IRA/401K income detection

I could be missing something, but I thought that was already covered by one of the answers. Also, I'm pretty sure the proper place to record and track that is in an Asset account, not Equity. As for the transactions, if you need to do virtual 'extra tracking' beyond just the physical

Re: [GNC] Script error message when searching

The attachment didn't come through. (it appears you're using Outlook and have an improper setting) But the search feature on the mailing list page does not work. Instead, you can view archives by topic, author, or time period. (and use your browser's Find feature from there) Or, you can go

Re: [GNC] How To Put Opening Balance in Acc Rev Account?5

Arthur, If you enter a negative amount into a register it will swap it to the other column. (debit/credit if using formal labels, left/right respectively otherwise - the labels change based on the account type.) The opening balance transaction should have been a credit (right column) to

Re: [GNC] How To Put Opening Balance in Acc Rev Account?

Usually entering manual transactions in the AR/AP accounts is discouraged because if you are using (or later decide to use) the Business Features, they will not see those transactions. The proper thing to do would be to Process Payment for the overpayment amount for the tenant (customer).

Re: [GNC] Changes in gnucash 4 vs 3

4.9 itself is a released version, but the packager may have built it against an earlier Ubuntu target, so it might not work properly. (the GnuCash team doesn't release .debs or maintain the Ubuntu repo version) Glad to hear you got it straight with a custom build. Maybe let the package

Re: [GNC] Changes in gnucash 4 vs 3

On 3/10/22 9:12 AM, Peter Ratzlaff wrote: Income accounts now have negative balances. Same for equity. Liability balance signs are flipped as well. That's a preference. Did other preferences not carry over? Investigate the Wiki for GnuCash storage locations and check to see if your

Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire

I second moving it to Using GnuCash. Regards, Adrien On 3/8/22 6:13 AM, D. via gnucash-user wrote: Geoff, Your points are valid. If we accept your assertions (and I'm willing to), my thinking is that this information might be better placed on the Using Gnucash page. David T.

Re: [GNC] Gnucash 3.8 Questions

The other questions were well answered, but I thought it important to mention about upgrading that you don't need to upgrade through each *minor* version, just the major versions. 3.x is a major version. 4.x is a major version. 5.x (due 2023) will be a major version. It is a good idea to

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

On 3/7/22 5:06 AM, flywire wrote: An invoice must be prepared for every rent due transaction and the payment processed. The 'preparing' is only the first time. After that, you just hit 'Duplicate' and enter the new posting date. 'Processing Payment' is how you apply a specific payment to a

Re: [GNC] reports

I think pretty much most if not all reports have the 'Accounts' tab in 'Options' where you select which accounts you want to report on. (the 'Account Report' being the one exception I can think of, since the account is already specified) You need to click the Options button on the toolbar,

Re: [GNC] don't know..

On 3/5/22 2:26 PM, arthur brogard via gnucash-user wrote: Not sure if I'm doing this right.  Hitting 'reply' on the email address of a poster that I want to respond to and putting a 'cc' in for gnucash-user@gnucash.org I see some people's posts seem to have been made to 'list gnucash' or

Re: [GNC] accounts receivable for rent..

On 3/5/22 10:32 AM, Michael or Penny Novack wrote: On 3/5/2022 4:03 AM, Adrien Monteleone wrote: On 3/5/22 12:50 AM, arthur brogard via gnucash-user wrote: We have only one property.  Only one tenant.  Simplest possible case I guess. I'm thinking I must: . Create an 'accounts receivable

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

And on that note, I highly stress to anyone getting started (or even old hands) to not try to artificially combine receipts for convenience. You could if you wanted to, but I guarantee, you'll want to 'refactor' some of those line items one day, or wish you could. Just enter receipts as

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

On 3/5/22 2:20 AM, flywire wrote: My concern is A/R is a lot of work just to get tenant statements if it's not used elsewhere. It is similar to the issue raised last month regarding tracking vehicles except for the regular rent due:

Re: [GNC] accounts receivable for rent..

On 3/5/22 12:50 AM, arthur brogard via gnucash-user wrote: We have only one property.  Only one tenant.  Simplest possible case I guess. I'm thinking I must: . Create an 'accounts receivable'  account.That would be an income account I guess.  'Other income' ? Accounts Receivable is an Asset

Re: [GNC] mac fails to open gnucash file

If you are getting a crash, you should file it on bugs.gnucash.org and attach your crash report there. Also, check the wiki about obtaining a TraceFile. That might be helpful as well. But first... I'm guessing you can start GnuCash since it crashes on exit. Can you navigate to File > Open

Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

Arthur, Yes. You can do this, but you'll need to decide based on your situation the best workflow. What you are describing is Accounts Receivable (AR). The Rent is due at a certain date and thus owing to you. Ideally, you want to 'book' the rent payment as due in the AR account as of that

Re: [GNC] Setting up Government Bond

What I read is to *not* set it up as a stock or fund, but rather just 'Asset'. Enter the purchase price. Record interest as it is accrued or at cash-out. No need to hassle with price-per-unit. If you buy another of the same bond and want to track them all in the same account, just add another

Re: [GNC] Profit & Retained Earning don't match

The Transaction Report has an 'Add options summary' flag, but it sadly does not show *all* options, very few of them in fact. Regards, Adrien On 2/25/22 4:01 PM, David Carlson wrote: I can't check right now but I think there is an enhancement request to show in a printable form all the

Re: [GNC] Report question

No need to open in a browser first. LibreOffice Calc can open/import an HTML table just fine, though you may want to play with formatting after. Regards, Adrien On 2/26/22 3:24 PM, davidcousen...@gmail.com wrote: Alternatively the menu item File->Export->Export Report will export the report

Re: [GNC] re Report unreliable (invalid totals)

As a test, remove the placeholder flag and see if the report shows a value now. Regards, Adrien On 2/27/22 5:43 PM, Bruce Irving wrote: Now I feel stupid! It turned out that a place holder account had an old balance. Once I got that cleared, the report balances. Still one minor problem:

Re: [GNC] Automatic sales tax

Our Legislature has set up at least 2 of those per year, and they can always do another or more one-offs. And at that, they aren't 'general' holidays. They only apply to the State rate, (and maybe not all of it at that) and then only to specific goods, and then not for written sales, but

Re: [GNC] Automatic sales tax

Tell them to try doing business in Louisiana. Ha! Regards, Adrien On 2/28/22 5:25 PM, Liz wrote: It's incredibly complex. And Australians have all been led to believe that we have the most complex tax system on the planet. ___ gnucash-user mailing

Re: [GNC] Automatic sales tax

The question is more likely one of 'when does the sale take place?' And for many jurisdictions, it takes place when 'good delivery has been made.' (when the revenue is earned, payment is irrelevant here) 1. So if you walk into a store, and walk out with goods, (paid or on credit) the point of

Re: [GNC] Reconcile Reset Please

Also, I'd try to avoid doing a large batch import. While it is slower, doing a month at a time, reconciling and then proceeding, the entire process will end up much faster. (the import matcher starts learning) And you have less to sift through at each reconciliation, thus less chance for human

Re: [GNC] Scheduled Invoices

Indeed, thanks! Regards, Adrien On 3/3/22 6:41 PM, Derek Atkins wrote: On Thu, March 3, 2022 7:11 pm, Adrien Monteleone wrote: I'm not sure if this is already formally filed as an enhancement on bugs.gnucash.org. Of course, I can't speak for when or if it will be implemented. https

Re: [GNC] Scheduled Invoices

No, there are only 2 ways to generate invoices: 1. Manually, either by keying them in by hand, or using the Duplicate button with one already open. 2. Importing a CSV. If you have more than just a handful to repeat, I'd opt for the CSV route. If the data is always the same, you could craft

Re: [GNC] Assign as payment missing

I too had this problem not long ago. Unfortunately, I don't recall how I resolved it. I'll investigate and report back. Marko, if you managed to fix it, please chime in with how you did so. Regards, Adrien On 2/8/22 8:35 PM, Marko Vukovic via gnucash-user wrote: I tried from both AR and

Re: [GNC] Setting up Government Bond

Check out Chapter 9 of the Tutorial & Concepts Guide: https://www.gnucash.org/viewdoc.phtml?doc=guide Set up a Asset account in your Chart where appropriate for the Bond and follow the Tutorial from there. Regards, Adrien On 2/23/22 9:43 AM, Suseno Dermawan wrote: Hi all, I'm recently new

Re: [GNC] reconcile problem?

Transactions won't reconcile themselves, but you can clear them either manually or via an import. If you opened a backup by mistake, that would result in something showing 'unreconciled' if the backup was before the reconciliation. The only way to get the 'y' to appear in the register is

Re: [GNC] reconcile problem?

There's no way to know without more detail why you're routinely off. And I'd probably never enter an adjusting transaction unless I'm absolutely certain of what it was. Considering you found an already reconciled transaction this month, could you perhaps be simply checking everything off each

Re: [GNC] column summary in transaction reports

Karl, before running your Account Report, do View > Filter by... and set your date range. Just don't forget you filtered the register view! (there is a 'Filtered' identifier in the upper-right of the register, but it is easy to miss) Regards, Adrien On 2/23/22 3:17 AM, Karl May wrote: Hi,

Re: [GNC] (no subject)

Mario, The wiki describes all locations used by GnuCash for each OS. You can use that info to fine tune your backups. Regards, Adrien On 2/22/22 11:49 AM, Mario Nigrovic wrote: Many years ago, I had used gnucash, and was pretty happy with it. I was very careful to make regular backups of my

Re: [GNC] Automatic sales tax

Keith, I’m not a mod. The instructions for unsubscribing are at the bottom of each e-mail. You have to do it yourself. You can turn on Digest Mode if you prefer in your preferences. Please don’t e-mail list members personally unless requested to do so, especially without copying the list.

Re: [GNC] Automatic sales tax

Yeah, without a receipt in hand (or electronic) showing the breakout, no software can assume or guess reliably. That is just insane. In my state, you can have one location in one jurisdiction depending on what side of the street it is on, and the two properties to the left and right can each

Re: [GNC] exporting search?

Indeed it does. I just did a test before reading this reply. For example, I have a quite detailed CoA, and I enter copious details in my Memo fields. I was curious to see how much I've spent on Fuggle hops for my Homebrewing hobby. I simply selected the appropriate expense category (and

Re: [GNC] Automatic sales tax

I'm confused, is this part of some other thread? Or just a drive-by? Yes, GnuCash can do sales tax calculations too. Are you having trouble figuring it out? And the bit about CC'ing the list is specifically so people keep all discussion on the list, and *not* e-mailing list members

<    8   9   10   11   12   13   14   15   16   17   >