[GNC] Exporting invoices and vendor bills to excel or Quickbooks

is there a way to export the list of invoices generated to excel? as well as the vendor bills inputted into the system? Scenario: We are a branch, and our main parent uses Quickbooks. Due to our low volume of transactions, it will be easier to maintain our part of the accounts separate, and jus

Re: [GNC] Can't get to GnuCash windows and menus

"After that, you have to start GnuCash first, then use File > Open to choose your book. You can't double-click a GnuCash file to open it." To amplify or clarify Adrien's comment on opening Gnucash under MacOS. When I double click on a Gnucash file, it does start Gnucash, but it opens the last f

Re: [GNC] access to backup Reports

*What does accessing spreadsheets have to due with backup reports for GnuCash?* ---***--- ̀Tis the reasonI think I lost access to previous reports when re installing gnucash ---***--- *If you installed GnuCash fresh on a new computer, you'll need to copy the 'saved-reports' files to their prope

Re: [GNC] access to backup Reports

Please don't repost questions in new threads. You received a reply the last time, but I don't see that you answered the question asked of you. I'm not sure what you mean by "not being able to access spreadsheets after upgrade, had to downgrade for that to work." What does accessing spreadsh

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

I thought the document number was assigned on creation, but I'd have to verify. (you can't delete an invoice for example, and you'd have to change the number to something like 'use next' if you made an error creating it) Of course, that would mean you get the same number for the invoice as th

[GNC] access to backup Reports

Have saved copy Gnucash/saved-reports-2.4-backup & Gnucash/saved-reports-2.4 from before, had to replace computer due to age & not being able to access spreadsheets after upgrade, had to downgrade for that to work. How can I now access & use the backup files? OK I am an end user using pop-OS Lin

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

On Wed, 29 Dec 2021 at 02:02, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > You might find luck playing with the Custom CSS stylesheet. > > Also, you can create/duplicate your own stylesheets and use one for > invoices and one for quotations. > > Regards, > Adrien Is there any way

Re: [GNC] Job Expenses? Job Profit Reports?

Oh. OK. That's fine. I'm just easily confused. Original Message From: Adrien Monteleone Sent: Tue Dec 28 21:56:10 EST 2021 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Job Expenses? Job Profit Reports? Me, sorry. I took a break for some time, and decided to look over

Re: [GNC] Job Expenses? Job Profit Reports?

Me, sorry. I took a break for some time, and decided to look over some threads that didn't get answers and see if I could help. A few other threads looked interesting and where I thought I could add to the discussion, decided to chime in. I happen to be all done now! (There are a few unans

Re: [GNC] Job Expenses? Job Profit Reports?

Adrien, You've submitted quite a few responses today to threads that are several months old. Is this something on your side, or the list's? David Original Message From: Adrien Monteleone Sent: Tue Dec 28 19:16:36 EST 2021 To: gnucash-u...@lists.gnucash.org Subject: Re: [GN

Re: [GNC] Description from Bill/Invoice not Posting on General Ledger Memo Field (GNU Cash V4.5)

By 'Descriptions' I'm guessing you mean the descriptions for the individual line items. (there is no generic 'description' field for a bill/invoice) The only way to see that is to uncheck the 'accumulate splits' box when posting. (alternatively, under Preferences > Business > General > 'Accum

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

You might find luck playing with the Custom CSS stylesheet. Also, you can create/duplicate your own stylesheets and use one for invoices and one for quotations. Regards, Adrien On 12/28/21 6:40 PM, Dr. David Kirkby wrote: Next I will need to sort out how to alter the report. I can see this i

Re: [GNC] Looking for an easy way to share Custom Reports (Windows 10) among users

I see you didn't get a reply on this so I'll hazard a suggestion... There is a thread from April '21 about upgrading from 2.6.21 to 4.x. This one in particular though also was about migrating computers. In that thread, Geert offered a detailed method for making sure your preferences and repor

Re: [GNC] Build scripts for ubuntu added to the wiki

Apologies, yes, that was sloppiness on my part. I was so focussed on making sure that the scripts would reliably build on different releases of ubuntu, I didn't add the last line to actually install it. I rectified that in the scripts on the wiki. Note that in future to build and install newer vers

Re: [GNC] Changing the order of splits

This might be overkill, but it might work too: You could create an 'Invoice' and list the players/teams as line items. (the 'Customer' here can just be 'Players' or some such and probably doesn't matter) In an invoice you *can* reorder the line items to suit your needs. (it can be cumbersome

Re: [GNC] Simple Update Question

If I recall correctly, the official policy is to support: 1. The last major GnuCash release, 2. On the oldest officially supported OS release. This doesn't mean older versions won't work, (some people are still in 2.6.x land!) or that newer versions won't necessarily work on older OS versions

Re: [GNC] budget report and scrolling

Not sure about LibreOffice, but for those on MacOS, Numbers.app lets you define 'groups' that you can expand and collapse with a click. You could then define each of your periods as a group, then expand/collapse to show/hide the Actual/Budget/Diff columns for each. Regards, Adrien On 8/6/21 6

Re: [GNC] Income statement report change

I'll hazard the suggestion to examine the main loop that spits out the account names and either prepend or append code that does: "if my special option is true, then lookup and output *this* data." You may have to rename the account name variable and concatenate the two under the original accou

Re: [GNC] Recurring Monthly bills, How to Auto Post... TFN ?

In addition to the other suggestions, there is a Duplicate Bill/Invoice button. Then make your edits before posting. Regards, Adrien On 8/13/21 1:23 PM, Fran_3 via gnucash-user wrote: Like many we have a number of regular monthly bills. Is there a way to have these bills "auto posted" each mon

Re: [GNC] Can't get to GnuCash windows and menus

Did you solve this? It sounds like you might be running GnuCash from inside the DMG. Be sure to copy the GnuCash.app from the DMG window to your Applications folder via Finder. (that is, open another Finder window set to Applications and then drag & drop the icon from the DMG to the Applicati

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

On Tue, 28 Dec 2021 at 22:16, Liz Dodd wrote: > On Tue, 28 Dec 2021 22:00:23 + > "Dr. David Kirkby" wrote: > > > I think there are some fudges to get around the inability to create a > > quotation, but what are they? I believe someone said create an > > invoice, but do not post it. Whilst I

Re: [GNC] Printing invoices and statements, Spanish language version stylesheets

Sounds like a Webkit problem with reports where I believe the workaround is to save the report, open it in a web browser and print from there - and 'poof', no blank page. I could be conflating bugs, but it won't hurt to give it a try. Regards, Adrien On 8/25/21 11:40 AM, rmom...@gmail.com wro

Re: [GNC] Search/report by description

Technically you can, *if* you don't 'accumulate splits' when posting. Then those line items will show up in all affected registers and you can use the Transaction Report's filtering options to get what you want. (or do a Find and then an Account Report) I wouldn't recommend un-posting and re-p

Re: [GNC] GNUCash & Macros

Hi Jack, I have automated receipt data entry into GnuCash with a PowerShell script and a receipt/invoice OCR API that runs daily for all of my books. For new transaction entries, there won't be an auto-complete so I then use a "hotkey" to activate macros to select the appropriate accounts. I can n

Re: [GNC] Job Expenses? Job Profit Reports?

The short answer is, "you can't." 'Jobs' aren't quite what the name implies. Rather, think 'Purchase Order'. There are various use cases the 'Jobs' feature does not work for: Multiple Customers (and even split with stock orders) for the same Job. Yeah, I know this sounds weird, but if a Job is

Re: [GNC] Scheduled Transaction Posting Order

There was a bug some time ago that was fixed for this with regular manual transactions, perhaps file another for Scheduled Transactions? (not certain why it would matter, but apparently it does) Deposits should I think in most, if not all, cases post before withdrawals. I've never found a bank

Re: [GNC] Billing Terms Editor not "sticky"

I've been using this feature since long before 3.8 and it has always worked. Be certain the *Customer/Vendor* has a defined term. The 'Billing Terms' dialog is to create a 'list of terms'. You then have to assign a term *from that list* to each and every Customer/Vendor if you want a Bill/Invo

Re: [GNC] Invoicing

If I understand what you are trying to do, you can't directly. 1. Create another income/revenue account. (if using the tax features, don't link it to anything) 2. Invoice the members with the line-item assigned to this other account. 3. After receiving payment create a transaction moving fund

Re: [GNC] Count Transactions

A similar approach could be by filtering and then using Export > Export Active Register to CSV. Open that CSV in a spreadsheet. Last Row # - 1 = transaction count. (-1 for the header row) This way you don't have possible label rows or individual splits to subtract also which may be the case de

Re: [GNC] difficulties with managing accounts with lots of split transactions

On 12/28/2021 5:39 PM, Adrien Monteleone wrote: Personally I use #2 as Transaction Journal & Double Line mode 24/7. The always visible detail doesn't bother me and I generally like to have it instantly available without having to change modes, but I understand mileage varies. Regards, Adrien

Re: [GNC] editing memorized transactions

GnuCash also has a 'Due Reminders' feature but you need to enter Bills/Invoices using the Business Features to see it and take advantage of it. (as distinct from Scheduled Transactions) Regards, Adrien On 10/29/21 1:59 PM, p...@kroitor.ca wrote: Both GnuCash and Quicken have the Scheduled Tra

Re: [GNC] difficulties with managing accounts with lots of split transactions

Personally I use #2 as Transaction Journal & Double Line mode 24/7. The always visible detail doesn't bother me and I generally like to have it instantly available without having to change modes, but I understand mileage varies. Regards, Adrien On 11/7/21 6:08 AM, Platon Pronko wrote: Hi! I

Re: [GNC] MEMORIZING PAYEE ADDRESS

What is your process? I first select the transaction, then go to File > Print Checks, and everything is filled out for me. Also, what OS/version are you using? Regards, Adrien On 11/10/21 12:22 PM, men...@fastmail.fm wrote: Hi I print checks occassionally using GnuCash. I find that the pr

Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE: provide access to filter-by on right-mouse-click in Accounts register

I think the idea was to remove it from the archives since it was link spam. Certainly, anyone who received the message has it in their own e-mail storage. But clearly, that is your call if you think it worth the trouble or not. Regards, Adrien On 12/28/21 3:48 PM, Liz Dodd wrote: No, it's an

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

That's the way to do it, but if you are getting no content, then you might not be opening the correct invoice. (or not actually opening any invoice) How are you (in detail) 'retrieving the invoice'? Regards, Adrien On 12/28/21 4:00 PM, Dr. David Kirkby wrote: I think there are some fudges t

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

On Tue, 28 Dec 2021 22:00:23 + "Dr. David Kirkby" wrote: > I think there are some fudges to get around the inability to create a > quotation, but what are they? I believe someone said create an > invoice, but do not post it. Whilst I can do this, and go back and > retrieve the invoice, the in

[GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

I thought I asked this question recently, and received a suggestion, but I can't get the suggestion to work. Sorry for the repetition. To me at least, one of the most annoying features of GnuCash is the inability to create a quotation. I believe this is not *strictly *an accounting issue, but the

Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE: provide access to filter-by on right-mouse-click in Accounts register

On Tue, 28 Dec 2021 15:37:27 -0600 Adrien Monteleone wrote: > On 11/5/21 12:37 PM, Michael Hendry wrote: > > > I take it there’s no way I can delete the post I sent which > > includes all those unwanted URLs? > > No but Liz probably can. > > Regards, > Adrien > No, it's an email list, and

Re: [GNC] GNUCash & Macros

Check this out: https://lists.gnucash.org/pipermail/gnucash-user/2017-February/069016.html Not sure if it is still available or works on your OS. Regards, Adrien On 5/26/21 9:52 AM, Jack Frillman via gnucash-user wrote: Does GNUCash have a macro feature? I searched the documentation and I d

Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE: provide access to filter-by on right-mouse-click in Accounts register

On 11/5/21 12:37 PM, Michael Hendry wrote: I take it there’s no way I can delete the post I sent which includes all those unwanted URLs? No but Liz probably can. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] How to copy open budget to spreadsheet

Not sure if you solved this but I see no one has replied. Run a Budget Report. (best to exclude the Actuals and Diff columns) Then copy/paste or save/open the resulting report in your favorite spreadsheet app. Regards, Adrien On 4/17/21 9:32 AM, Morris Beavers wrote: Hello GNUCash, My vers

Re: [GNC] Real Estate property-segregated costs tracking

On 12/27/2021 10:26 PM, Juan F. Saa wrote: Does anyone use GnuCash to keep track of wholesaling/flipping of Real Estate properties? In Quickbooks this is done by entering each property as a 'class', as described here That's an "add on" to standard double entry bookkeeping. Standard double ent

Re: [GNC] Question on opening files

Are you possibility opening from a desktop shortcut? If so, right click > Properties and make sure Minimized is not selected in "Run" as shows in the attached screenshot. On Tue, Dec 28, 2021 at 10:30 AM Charles Vincent < memb...@ecolefrancaisedebattambang.org> wrote: > Repeating copying... > >

Re: [GNC] Question on opening files

Repeating copying... Windows10. I just opened up a file just sent to me without problems. It appears to affect older files, ( the one I need was saved in March 2021). *Charles * On Tue, Dec 28, 2021 at 4:24 PM Gyle McCollam wrote: > Charles, Question, what operating system are you using?

Re: [GNC] Question on opening files

Charles, Question, what operating system are you using? Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com email From: gnucash-user on behalf of Charles Vincent Sent:

[GNC] Question on opening files

For the last few weeks, i have noticed that some gnucash files which I had saved open but are minimized and cannot be restored maximized. Anyone else encountering this issue and any suggestions? Thank you *Charles * ___ gnucash-user mailing list gnucash

Re: [GNC] On line quote debugging help

Oh, sorry, my bad. Yes that is the question - why are some of the quote sources greyed out, and follow on question is: is there a way to edit that list to toggle the source? -Original Message- From: john Sent: Monday, December 27, 2021 11:28 PM To: Kalpesh Patel Cc: gnucash-user@gnucas

Re: [GNC] Reports, how to use

Cant u import the accounts and transactions? On Mon., Dec. 27, 2021, 18:22 Chuck, wrote: > Have copy Gnucash/saved-reports-2.4-backup & > Gnucash/saved-reports-2.4 from before, had to replace computer due to age & > not being able to access spreadsheets after upgrade, had to downgrade for > that