Re: [GNC] Multiple currencies and business functions

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

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

[GNC] Multiple currencies and business functions

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

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

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

[GNC] re-adding billable expenses to an invoice

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

Re: [GNC] Modifying business function splits

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 item

[GNC] Modifying business function splits

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

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

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

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 documentation > cor

[GNC] Billing employee expenses back to a customer

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)

. > > 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)

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

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

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 e

[GNC] Posting sales in multiple currencies (2.6.21)

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

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

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. >

[GNC] Deleting an unused tax table (2.6.21)

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,

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

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.

Re: [GNC] Modelling employee expenses

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

[GNC] Invoice tax rouding issue in 2.x

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

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

Re: [GNC] Modelling employee expenses

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

Re: [GNC] Modelling employee expenses

On 22 May 2018 at 18:21, Rich Shepard <rshep...@appl-ecosys.com> 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 ti

[GNC] Modelling employee expenses

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,

Re: [GNC] help setting accounts to track contributions

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 >>

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

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

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

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:

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

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

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

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

Re: Compiling -DWITH_GNUCASH=NO

On 23 March 2018 at 11:59, John Ralls <jra...@ceridwen.us> wrote: > > > On Mar 23, 2018, at 8:34 AM, Matthew Pounsett <m...@conundrum.com> wrote: > > On 23 March 2018 at 00:35, Geert Janssens <geert.gnuc...@kobaltwit.be> > wrote: > > > Ideally this wou

Re: Compiling -DWITH_GNUCASH=NO

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

Re: Wrong balance after entering transaction after import

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

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

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 >

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

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: > >

Re: Printing Hard Copy

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

Re: Church Use of GNUCash

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

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

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

Re: Scheduled transactions

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

Re: budget

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

Window location

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

Re: Version Migration

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

Re: Version Migration

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

High-balance reporting?

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

Re: Version Migration

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 >