Re: [GNC] Multiple currencies and business functions

2018-11-06 Thread Matthew Pounsett
On Tue, 6 Nov 2018 at 15:30, Christian Kluge wrote: > > The currency logic is pretty simple: every amount you see in the invoice > > entries is assumed to be in the customer's default currency. They income > > account for each entry can be in a currency different from the invoice > > account. In

Re: [GNC] Multiple currencies and business functions

2018-11-06 Thread Matthew Pounsett
On Tue, 6 Nov 2018 at 12:22, Geert Janssens wrote: > I believe you have just pushed the boundaries of what to do with invoices > further than anyone ever could have imagined :) > Good? :) > > I don't think anyone so far ever considered the case of having billable > expenses in a different curr

[GNC] Multiple currencies and business functions

2018-11-06 Thread Matthew Pounsett
I have cases with both billable employee expenses (vouchers) and billable purchases (vendor bills) which need to go on customer invoices. This is fairly straight forward... the problem I'm having is how to deal with these when the currency I'm entering the voucher or bill in is not the same as th

Re: [GNC] re-adding billable expenses to an invoice

2018-09-06 Thread Matthew Pounsett
On 6 September 2018 at 12:04, Derek Atkins wrote: > Matthew Pounsett writes: > > > I accidentally flubbed some keyboard entry while putting together an > > invoice and messed up a billable expense item which had been > automatically > > added when the invoice was

[GNC] re-adding billable expenses to an invoice

2018-09-05 Thread Matthew Pounsett
I accidentally flubbed some keyboard entry while putting together an invoice and messed up a billable expense item which had been automatically added when the invoice was created. Since there is no "Undo" the best option seemed to be to delete the entry and start over, but I can't find a way to in

Re: [GNC] Modifying business function splits

2018-06-10 Thread Matthew Pounsett
On 10 June 2018 at 06:22, Geert Janssens wrote: > Op zaterdag 9 juni 2018 15:50:13 CEST schreef Matthew Pounsett: > > My clients typically pay me by wire, and when my bank presents the > > transaction it's as the received wire and their service fee as a single > > line

[GNC] Modifying business function splits

2018-06-09 Thread Matthew Pounsett
My clients typically pay me by wire, and when my bank presents the transaction it's as the received wire and their service fee as a single line item in my statement. My inclination is to modify the split created by "process payment" and add the service fee to it rather than add the service fee as

Re: [GNC] Billing employee expenses back to a customer

2018-06-09 Thread Matthew Pounsett
On 9 June 2018 at 03:40, Christoph R wrote: > Hi Matthew, > > You need to first press the button “Edit Invoice”. Then you can change the > customer. > > Aha! Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription pre

Re: [GNC] Billing employee expenses back to a customer

2018-06-08 Thread Matthew Pounsett
Sorry, I failed to note I'm seeing this issue in GnuCash 2.6.21 on MacOS 10.13.3 On 8 June 2018 at 20:41, Matthew Pounsett wrote: > I'm entering an employee expense voucher that includes some receipts that > are billable back to a customer. If I'm reading the documen

[GNC] Billing employee expenses back to a customer

2018-06-08 Thread Matthew Pounsett
I'm entering an employee expense voucher that includes some receipts that are billable back to a customer. If I'm reading the documentation correctly, I should be able to enter a customer name in the "Default chargeback project - Customer" field, and then mark individual line items as billable in

Re: [GNC] Posting sales in multiple currencies (2.6.21)

2018-06-02 Thread Matthew Pounsett
. > > But if you can do as I suppose, you could eliminate the complication of > extra accounts and the placeholder issue and just use the A/R account as > normal. (save for the conversions done for foreign billing and the > conversion on several reports) > > Regards, > Adri

Re: [GNC] Posting sales in multiple currencies (2.6.21)

2018-06-01 Thread Matthew Pounsett
A short aside.. I think there may still be a bug here. Even though Assets:Accounts Receivable is set to Placeholder, it gets offered as a choice for posting to when I'm posting an invoice... only when I try to post to it I get an error that I'm trying to post to a placeholder account. It should p

Re: [GNC] Posting sales in multiple currencies (2.6.21)

2018-06-01 Thread Matthew Pounsett
On 1 June 2018 at 09:33, Matthew Pounsett wrote: > > > Have I missed something? > > Apparently I have.. I missed the Currency setting in the customer setup. The odd thing is that I specifically went and looked for that. But didn't find it until after I hit send on the

[GNC] Posting sales in multiple currencies (2.6.21)

2018-06-01 Thread Matthew Pounsett
I have clients that get billed in their home currency. I see what looks like multiple bugs in handling this in GnuCash, and so I think maybe I'm doing something wrong. I have the following accounts in a test file where the default currency is CAD. Notes about each account's configuration in pare

Re: [GNC] Deleting an unused tax table (2.6.21)

2018-05-25 Thread Matthew Pounsett
On 25 May 2018 at 11:33, Geert Janssens wrote: > Op vrijdag 25 mei 2018 17:29:04 CEST schreef Derek Atkins: > > I thought the name was changeable? I'm not sure why it wouldn't be. > > I think it's not. I happened to be searching for that as well a few days > back. > Probably an omission ? > > Ye

[GNC] Deleting an unused tax table (2.6.21)

2018-05-23 Thread Matthew Pounsett
After setting up my tax tables I realized it would be best if I renamed one of the tables I had already created and used, but there is no rename function. So, I created a new table using the name I wanted, and went through each Vendor Bill that used the old table (there are only two) to unpost, ch

Re: [GNC] Invoice tax rouding issue in 2.x

2018-05-23 Thread Matthew Pounsett
Thanks for all your replies. If just the people who have replied in the last 12 hours is any indication, then a lot of people are "living with" a fairly annoying bug. In my case, this is on an invoice I'm generating, not a bill, so I don't feel like I can mess with the data too much. Fortunately

Re: [GNC] Modelling employee expenses

2018-05-22 Thread Matthew Pounsett
On 22 May 2018 at 21:02, Adrien Monteleone wrote: > > > > > > There isn't a way to make a line item in an employee voucher taxable (no > taxable checkbox, and no field to specify a tax table). But with a bit of > math I could reduce the unit price of a taxable item and then add a tax > line afte

[GNC] Invoice tax rouding issue in 2.x

2018-05-22 Thread Matthew Pounsett
I've got an off-by-a-cent error on an invoice due to the way taxes are calculated. GnuCash (2.6.21) is calculating the tax on each individual taxable item, then summing that up, and adding that value to the subtotal. This causes an error because each individual tax calculation is rounded prior to

Re: [GNC] Modelling employee expenses

2018-05-22 Thread Matthew Pounsett
On 22 May 2018 at 19:36, Adrien Monteleone wrote: > Sales Tax on sales is *not* an expense or revenue. You shouldn’t need to > balance it against anything. It’s a pass-through liability.‡ It should have > no bearing on your books other than you have to collect it and remit it. > Sales tax on sal

Re: [GNC] Modelling employee expenses

2018-05-22 Thread Matthew Pounsett
On 22 May 2018 at 19:20, Adrien Monteleone wrote: > Matt, > > There are others using vouchers on this list as I’ve seen threads on the > tax issue before. Try a list search and you might find something helpful. > (prefix your search terms with ’site:lists.gnucash.org’ without the > quotes) > > On

Re: [GNC] Modelling employee expenses

2018-05-22 Thread Matthew Pounsett
On 22 May 2018 at 18:59, Rich Shepard wrote: > I'm confused by the above. Do you get a bill from a vendor (e.g., Office > Depot) for something, and an expense voucher from an employee for the same > item? > No, I have an expense item from an employee which they need to be reimbursed for. The

Re: [GNC] Modelling employee expenses

2018-05-22 Thread Matthew Pounsett
On 22 May 2018 at 18:21, Rich Shepard wrote: > On Tue, 22 May 2018, Matthew Pounsett wrote: > > So.. I'd like to assign employee expenses to some other account type, and >> enter the receipts as vendor bills. I'm trying to decide how to tie the >> two together

[GNC] Modelling employee expenses

2018-05-22 Thread Matthew Pounsett
I'm just starting to use the business functions of GnuCash.. most things I've sorted out fairly easily, but I'm having issues figuring out the best way to use Employee expense vouchers. The intended use looks pretty straightforward: enter line items attached to the appropriate expense account, pos

Re: [GNC] help setting accounts to track contributions

2018-05-04 Thread Matthew Pounsett
On 4 May 2018 at 09:05, Mike or Penny Novack wrote: > On 5/4/2018 4:13 AM, Gio Bacareza wrote: > >> Hi, >> >> My partner and I are moving in together and we'd like to share expenses >> like groceries, rent, etc. So we'd like to track expenses as well as our >> appropriate contributions to make su

Re: [GNC] help setting accounts to track contributions

2018-05-04 Thread Matthew Pounsett
On 4 May 2018 at 04:13, Gio Bacareza wrote: > Hi, > > My partner and I are moving in together and we'd like to share expenses > like groceries, rent, etc. So we'd like to track expenses as well as our > appropriate contributions to make sure that we both are contributing > equally to house expens

Re: [GNC] Include unused accounts in budgets, and behaviour of placeholder accounts in budgets

2018-04-14 Thread Matthew Pounsett
On 13 April 2018 at 11:11, Ankur Sinha wrote: > I've a query regarding placeholder accounts in the budget view too. My > "dining" account has two sub accounts: "drinks", and "food", for > example. Dining is a "placeholder" account and the values associated > with it show in light grey colour in t

Re: [GNC] future of custom reports in 3.x

2018-04-10 Thread Matthew Pounsett
Thanks very much to William, David, and Sébastien for those links. That's all the documentation I could want. Cheers! Matt ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists

Re: [GNC] future of custom reports in 3.x

2018-04-10 Thread Matthew Pounsett
On 10 April 2018 at 11:45, Amish wrote: > May be fastest and easiest way would be to first save sample data (say > only 1 transaction) to say PostgreSQL database and then use pg_dump to dump > it to text file. > > That's an approach, for sure. However... there are 24 tables just in my personal

Re: [GNC] future of custom reports in 3.x

2018-04-10 Thread Matthew Pounsett
On 8 April 2018 at 13:13, John Ralls wrote: > > In the meantime there are four alternatives for custom reports: > 2. Learn SQL and use a SQL backend to extract the data you want. The > results are generally amenable to import into a spreadsheet for further > processing; you could also install the

Re: Compiling -DWITH_GNUCASH=NO

2018-03-24 Thread Matthew Pounsett
On 23 March 2018 at 11:59, John Ralls wrote: > > > On Mar 23, 2018, at 8:34 AM, Matthew Pounsett wrote: > > On 23 March 2018 at 00:35, Geert Janssens > wrote: > > > Ideally this would become part of libgnucash in order to make the report > generation platform

Re: Compiling -DWITH_GNUCASH=NO

2018-03-23 Thread Matthew Pounsett
On 23 March 2018 at 00:35, Geert Janssens wrote: > > Ideally this would become part of libgnucash in order to make the report > generation platform independent as well (and hence opening the way to make > it > accessible one day on android or osx platforms). This will only be > possible at > the

Re: Wrong balance after entering transaction after import

2018-03-21 Thread Matthew Pounsett
On 21 March 2018 at 22:29, BPleasantHill wrote: > Hi: > > I am new to GnuCash and am converting from Quicken. > > *Problem Summary* > I created a checking account, set a starting balance, and imported my > quicken QIF file. Then I adjusted the Opening Balance. Everything is OK. > Finally I entere

Re: How to deal with RRSP's (Canada)

2018-01-04 Thread Matthew Pounsett
On 3 January 2018 at 22:11, Cam Ellison wrote: > >> The examples I used were (perhaps over-) simplifications. In practice, I > actually have a number of stocks and money market accounts within two RIFs, > like so: > > Assets:investments:RIF:Stock1 > Assets:Investments:RIF:Stock2 > Assets:Investme

Re: How to deal with RRSP's (Canada)

2018-01-03 Thread Matthew Pounsett
I am not an accountant.. or even a bookkeeper.. but here's how I deal with RRSPs. > >> For me, the RRSPs have been converted to Income Funds, but the principle > and procedure are still the same. Contribution is straightforward: from a > Current Asset account to the RRSP, like this: > > Assets:Cu

Re: Printing Hard Copy

2018-01-03 Thread Matthew Pounsett
On 3 January 2018 at 13:28, Derek Atkins wrote: > Hi, > > rj ruble writes: > > > How can I print my accounts to hard copy? > > Generate the appropriate report that shows the accounts as you want, and > then you can print the report. > > Is there a report that reproduces a Basic, Auto-Split, or T

Re: Church Use of GNUCash

2017-12-20 Thread Matthew Pounsett
On 20 December 2017 at 14:40, jcnw wrote: > I am setting up our church books on GNUCash and wonder how to handle > restricted funds. > For example if a member makes a donation to The Organ Fund > > I'd suggest adding it to a subaccount of whatever actual account the funds are deposited to. e.g.

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread Matthew Pounsett
On 10 October 2017 at 15:15, Carsten Rinke wrote: > Hi Ben, > > what do you mean by machine specific? > > If you transfer your gnucash data file between machines, I thought it > should also possible to transfer the saved-reports-2.x file between the > machines. > It probably is, but it's not tri

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

2017-09-26 Thread Matthew Pounsett
On 25 September 2017 at 22:20, Explorare H. David wrote: > So the best solution for me is to make a scheduled payment after I got > CC bill? This would help me a lot, I think. And "Future Minimum" is a > useful feature. > > If you're talking about creating that each time you receive a bill, then

Re: Scheduled transactions

2017-09-25 Thread Matthew Pounsett
On 25 September 2017 at 10:57, wrote: > Is there a way to tell GnuCash to process a scheduled transaction early > other than to chance the date of each transaction? Some months I would like > to do my monthly accounting earlier than the first of the month. Only way I > have found to do that is to

Re: budget

2017-09-21 Thread Matthew Pounsett
On 21 September 2017 at 09:50, Phil Longstaff wrote: > I find envelope budgeting good for some expense types but not as good for > others. For something like groceries or rent which are even over the year, > it is good. For something like a trip which has 0 expense for most months > but a large e

Window location

2017-09-19 Thread Matthew Pounsett
Hi all. I work in a bit of an edge case, in that I have a very large desktop (just shy of 7k pixels wide, over 1.5 meters of physical distance). The main gnucash window seems to save its location and always open where it was last closed. This is awesome. However, nearly every other window (I th

Re: Version Migration

2017-09-05 Thread Matthew Pounsett
On 31 August 2017 at 22:58, John Ralls wrote: > > > > On Aug 31, 2017, at 2:36 PM, Mike or Penny Novack < > stepbystepf...@dialup4less.com> wrote: > > > > Are folks saying that sqlite3 does NOT come with a backup/restore > utility? I would think that at least somewhat strange. > > Not a bit. I ju

Re: High-balance reporting?

2017-08-31 Thread Matthew Pounsett
On 31 August 2017 at 14:29, John Ralls wrote: > > > There's no report that does it directly, but you can get there by running > the Asset Barchart report on just the one account with the appropriate date > range, frequency set to "day" and show table checked. > Hmm.. a bit awkward, but it'd work

Re: Version Migration

2017-08-31 Thread Matthew Pounsett
On 31 August 2017 at 13:33, Geert Janssens wrote: > > While these solutions will work most of the time they all have the same > risk: > if the snapshot is made while gnucash is updating the db, you end up with > an > inconsistent db file. I don't know how well sqlite3 handles this so the > risk >

High-balance reporting?

2017-08-31 Thread Matthew Pounsett
I've been poking around in GnuCash trying to find a way to report on the high balance for a list of accounts in a given period. This would be hugely helpful in FBAR reporting (Foreign Bank and Financial Accounting Report) for the IRS. I imagine I'm going to need to look into writing custom report

Re: Version Migration

2017-08-31 Thread Matthew Pounsett
On 31 August 2017 at 12:27, John Ralls wrote: > > > It also doesn't make backups, so unless the user does there's no way to > roll back to an earlier state. Since all changes are immediately written to > storage there's also no way to abandon a bunch of changes by quitting > without saving. > > I