Re: [GNC] Multiple currencies and business functions

[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 that case a currency conversion will be applied when posting
> this
> > amount to the income account. But as amounts for billable items come
> from the
> > entries, they are assumed to be in the customer's currency.
>
>
> That’s why my solution would be never to income and expense accounts in
> foreign currencies, but only assets and liability accounts in addition
> to the trading accounts.
>

Expense accounts mostly get smoothed into one currency by the effects of
having banks convert on deposit or charge in bank accounts and credit
cards.  Although I still have to deal with foreign currency service charges
on international wire transfers.

I don't think it's reasonable to expect to have only one income currency
with international clients.


> For the actual problem my solution would be as follows.
>
> [..]


> The last operation would be to add a transaction from the temporary CAD
> asset account to your normal USD income account.
>
>
I had to read it a few times, but I think I follow that.  I'll give it a
shot later and see what happens.
Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple currencies and business functions

[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 currency from the invoice currency. And from what
> you
> tell I gather it's currently not supported.
>

I'm a little surprised.  It seems like an obvious situation to me.  Between
travel, foreign clients, or just import/export it seems like something that
would come up at least occasionally.

In my case there's a combination of travel (I post expenses in a half dozen
currencies) and having International clients that want to be billed in
their home currency.


>
> Can I ask you to file this as a bug report in bugzilla ? Refer to http://
> wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker.
>
>
Sure.  I'll get that in tonight.


>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Multiple currencies and business functions

[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
the customer's invoice currency.

To use a concrete example, say I've got a $100 employee expense in CAD that
gets marked as billable.  If I have a client whose default currency is USD,
when the item is added it appears with the CAD value ($100) but is added up
in the total at the bottom as if it's USD.

Is there a step I'm missing somewhere to get it to show up as a USD value
in the invoice?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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 instruct GnuCash to add billable items to an invoice.  It seems to
> > do it automatically at invoice creation, and no other way.
> >
> > Am I missing something?
>
> When you are editing the invoice, just click in the "Billable" column
> when adding the line-item to mark it as billable.
>

I think you've misunderstood the question.   There are already billable
expenses in the system.  I'm generating the invoice in which those billable
items will be passed on to the client.

I need to re-add the billable expenses to the invoice.  There doesn't
appear to be a way to do that... it looks like they are only added when the
invoice is first created.. I can't find any button, menu, or anything else
that would trigger adding billable expenses to an existing invoice.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] re-adding billable expenses to an invoice

[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 instruct GnuCash to add billable items to an invoice.  It seems to
do it automatically at invoice creation, and no other way.

Am I missing something?

GnuCash 2.6.21.

Thanks!
   Matt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Modifying business function splits

[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 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 a separate transaction.  Am I likely to cause any problems
> > by modifying a transaction that was created automatically?
>
> You should be able to do so without causing trouble. Just be careful not
> to
> touch the Accounts Receivable split of your payment transaction.


Yeah.. no interest in changing the line that debits my AR account.. just
want to add a line that debits my bank charges expense and modify the
credit to my chequing account accordingly.

Thanks!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Modifying business function splits

[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 a separate transaction.  Am I likely to cause any problems
by modifying a transaction that was created automatically?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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 order for them to show up in the customer account.
>
> However, when I place the cursor in the customer field and try to type I
> get system beeps, indicating that I can't type in that field.  And the Edit
> button next to the field doesn't seem to do anything.
>
> Have I missed a step somewhere?  I have not set up any Jobs.. do I need to
> do that in order to bill back?
>
> A side note.. the documentation text for the Customer and Job fields is
> identical to each other in both the v2.6 and v3 docs.  It looks like the
> Customer description was C into the Job description and then not updated.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Billing employee expenses back to a customer

[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 order for them to show up in the customer account.

However, when I place the cursor in the customer field and try to type I
get system beeps, indicating that I can't type in that field.  And the Edit
button next to the field doesn't seem to do anything.

Have I missed a step somewhere?  I have not set up any Jobs.. do I need to
do that in order to bill back?

A side note.. the documentation text for the Customer and Job fields is
identical to each other in both the v2.6 and v3 docs.  It looks like the
Customer description was C into the Job description and then not updated.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Matthew Pounsett]

On Sat, Jun 2, 2018 at 00:14 Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Just out of curiosity, can you not post a CAD invoice to an A/R account
> that is set for USD?
>
> I would have thought that GnuCash would have done the conversions for you.


I don’t think you would actually want to do this. The delay between posting
the invoice and receiving a payment leaves a huge potoetmtial for
discrepancy between any conversion done at post time and the conversion
done at the time of deposit.

I have several A/R accounts now, but wires from my clients all go into an
account in my home currency.. so when I do the payment I just enter the
conversion rate that my bank gave me at deposit time and it all balances
out without having to go back and correct anything after the fact.


>
> Thankfully, I don’t have that problem (yet) but my first inclination would
> be to do just that: maintain MY A/R account in my home currency but invoice
> customers in their home currency. I don’t see why it would be any different
> than any other transaction posted into an account with a different currency
> default. Perhaps I’m misunderstanding something.
>
> 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,
> Adrien
>
> > On Jun 1, 2018, at 8:39 AM, Matthew Pounsett  wrote:
> >
> > 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 probably be excluded from the list of choices.
> >
> > I'll add that to the bugtracker.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 probably be excluded from the list of choices.

I'll add that to the bugtracker.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 email.
Apologies for inflicting my caffeine deprived morning on everyone's
mailbox.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Posting sales in multiple currencies (2.6.21)

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

Assets:Accounts Receivable  (placeholder, currency CAD)
Assets:Accounts Receivable:CAD (currency CAD)
Assets:Accounts Receivable:USD (currency USD)
Income:Sales (placeholder, currency CAD)
Income:Sales:CAD (currency CAD)
Income:Sales:USD (currency USD)

When I create invoices and post them to accounts receivable in CAD
everything works as expected.

When I create an invoice and the Income Account is in USD, the summary at
the bottom of the dialogue (Total/Subtotal/Tax) is listed as CAD but not
converted.   For example, if I have an item with the income account set to
Income:Sales:USD, quantity 1, unit price 100.00, then the summary at the
bottom shows Total: C$100.00 Subtotal: C$100.00 Tax: C$0.00.

That's the first problem, but not very serious so I was going to just
ignore it.  However, the second problem is bigger... I'm unable to post the
invoice to Assets:Accounts Receivable:USD.

Since I'm billing in USD, and will get paid in USD, and the conversion to
CAD won't happen until (or if) I deposit the payment into my CAD account, I
should be able to track this in USD up until that point, but it doesn't
look like I can.

Have I missed something?

Thanks!
   Matt
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 ?
>
> Yeah.  there's no rename function in the tax table dialogue box.  I found
an older email about that where the answer was effectively "yeah, sorry, we
never got around to adding that feature."

I can go to a backup of the sql file and manually rename the tax table.

Thanks for your thorough explanation Derek.  It makes perfect sense why I
can't delete the table, now.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Deleting an unused tax table (2.6.21)

[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, change the table used, and repost.

Then I went to delete the old (now unused) table, but I'm told by GnuCash
that it can't be deleted because it's in use.

After re-checking every bill, invoice, and voucher to be absolutely sure
the table is not in use, I decided to go check the data.  I see that the
taxtables are self-referential in a way that I didn't expect.

sqlite> .schema taxtables
CREATE TABLE taxtables (guid text(32) PRIMARY KEY NOT NULL, name text(50)
NOT NULL, refcount bigint NOT NULL, invisible integer NOT NULL, parent
text(32));
sqlite> select * from taxtables;
55313ec8ff87ef9980a3f4074ef6d563|Sales GST/HST|6|0|
d5be527bcf650c1bcf0b074dcdd6ebf0|Purchase GST/HST|1|0|
3a79f406381f325cad492f4840ea5c82|Sales
GST/HST|0|1|55313ec8ff87ef9980a3f4074ef6d563
a445251ce460d86faf71d7e61500e104|Purchase
GST/HST|0|1|d5be527bcf650c1bcf0b074dcdd6ebf0
6c23f3dcacf149dcfdc5b28f1d1030b1|Purchase GST/HST (ITC)|2|0|
89f9159bbc7e05aed2a93a5af6dd5c0e|Purchase GST/HST (Non-ITC)|0|0|
de880de6ccd478fb1f707f8b145f55d2|Purchase GST/HST
(ITC)|0|1|6c23f3dcacf149dcfdc5b28f1d1030b1

It's the "Purchase GST/HST" table I'd like to delete.  If I'm getting the
sense of the boolean correct, then there is a hidden version with a
refcount of 1, and an unhidden version with a refcount of 0 that references
the former entry.  If the unhidden one is what appears in the UI, then I'm
confused as to why its refcount of 0 prevents me from deleting it.

Any thoughts on how I can fix this up?  I don't want to just delete records
from this table as I'm not sure what else might be referencing it (I'm
still working on understanding the relations in the db).

In googling while troublehsooting I wasn't able to find anyone who had this
exact problem, but I did find some references on renaming tax tables by
going around the UI.  Seeing that it's safe to do so I could revert to an
older save file and directly rename the tax table.. but I'd still like to
understand what the problem is here.  If it's something I've missed... a
bug.. or what.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 (or not) I'm not
using GnuCash to actually generate the invoice that goes to the customer,
since I find them poorly implemented as well... so the invoice is just for
internal records.  But that means it needs to match what I actually send
the customer fairly accurately, or things get "off".

My workaround is to add -$0.01 item that is non-taxable but is posted to my
tax table's liability 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Modelling employee expenses

[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 after it.  It’s a bit finicky, but I think it'd work.
>
> I was about to note that math wasn’t necessary, but I see from your other
> reply, you are in a VAT jurisdiction. If the receipts don’t specify the VAT
> amount separately, then yes, you’ll have to do some math. Fortunately,
> GnuCash can help. You can enter math operators directly into quantity and
> value fields and it will do the heavy lifting.


Yeah, I do that sort of thing all over the place within GnuCash.

I ended up being forced to go back to separating out the taxes in the
employee voucher because paying off a bill from a liability doesn't quite
work right.  The issue is that the tax on the bill is applied to the
correct tax liability, but there's nothing to offset that in the employee
reimbursement liability.  So when I finish paying off everything, it
doesn't balance out.

Doing this "the hard way" by entering tax-creditable employee expenses as
two line items is less work than trying to figure out how to balance the
tax transaction correctly.

Thanks very much to everyone who responded to this thread.. even though I
didn't find a way to do this as I'd like, it's been a very helpful
discussion.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Invoice tax rouding issue in 2.x

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

Given a tax rate of 13%, GnuCash is doing this:

Item Tax
  277.50   36.08
   92.50   12.03
Subtotal: 370.00 + 48.11 = 418.11

When the real calculation should be:

Item  Tax
  277.50   36.075
   92.50   12.025
Subtotal: 370.00 + 48.100 = 418.10

This could be fixed by GnuCash not rounding tax amounts until the final
total, but typically I believe the calculation done is to add up all the
taxable items and apply the tax calculation to that subtotal, so that it's
not necessary to track many decimal places to avoid a rounding error.

I did some searching through the mailing lists and I see a lot of reported
issues about rounding errors in GnuCash 2.x.  I can work around this by
putting in an extra line item to correct the taxes, but it would be nice
not to have to do that.  Is this something that's been fixed in 3.x?  I've
been avoiding the update because I haven't had time for a careful
migration, and testing whether I'm affected by any of the various issues
that have been reported since its release.  But, this might be a reason to
set that time aside.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Modelling employee expenses

[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 sales is a positive liability that needs to be paid to the
government.  Sales tax on purchases is a negative liability that offsets
sales tax on sales, and reduces the amount payable to the government.  So,
I need to track it.


>
> Note, if you are in a VAT jurisdiction and you are reimbursing for
> services, product or materials that will be resold/incorporated into a
> final product, then you have a complication with tracking the VAT paid on
> those expenses. (which there is another thread on the list in the last 3-4
> months about as I mentioned.)
>

Yes, exactly.  See above.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Modelling employee expenses

[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 the #1:
>
> Don’t consolidate splits when you post the voucher. (should be an option
> near the bottom of the post window) That will show the individual splits in
> the relevant account registers. (same goes for bills and invoices)
>

Ah okay.. that will help, I think


>
> #2:
>
> There are two approaches I can think of, one works well with my above
> recommendation for #1, the second does not.
>
> If you’re entering line items that are being re-imbursed, why not just
> enter a line item for the tax? (costing it to Expenses:Sales Taxes or
> something similar)
> This way you’ll account for it properly and be able to see it in the
> registers clearly.
>
> Alternatively, I think I recall someone discussing here before that they
> set up a special tax rate that was tied to their Expenses:Sales Taxes
> account just for use with employee vouchers. (I don’t recall the purpose of
> a special rate for this, but it seemed to make sense at the time) Then they
> just entered expense items as taxable and used that rate. The voucher
> posted the correct tax to the proper account. (they also had a VAT
> complication which is what I think they were trying to sort out in the
> thread)
>

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 after it.  It's a bit finicky, but I think it'd work.

While testing out various options based on your email I realized I have
another reason for getting employee expenses into bills:  I've got a few
cases where a regular supplier's bills have been paid out of pocket rather
than direct from the company.  It'd be nice to have those tracked along
side the bills that are paid normally.


> If you could cleanly enter the expenses as Vendor Bills, you could pay
> them with offsets to a Liabilities:Employee Expenses account. (skipping the
> Voucher entirely and transferring one liability to another.) Then when you
> reimburse the employee, you pay that with an asset. There isn’t much point
> in this however unless you really need to track how much those employees
> (and ultimately, you) spent at each Vendor. Because each one will be
> immediately ‘paid’ with the offsetting liability to the employee, there
> won’t be any related payables aging from the Vendor Bill that is trackable
> any more.
>

To make sure I understand what you're suggesting.. that'd be

1) enter employee expenses as vendor bills, posted to Liabilities:Employee
Expenses instead of the relevant expense account, pay from assets as usual
2) enter vendor bills, posted to the appropriate expense account, pay from
Liabilities:Employee Expenses?

That seems like it could work.  It's similar to what I was suggesting
before, just using vendor bills instead of employee vouchers for #1.


>
> Or, if you really needed to track Employee Expenses due separate from A/P,
> and still want to use the voucher system, then ‘pay’ the Voucher with a
> similar offset to the Liabilities:Employee Expenses account. Then later pay
> down that account from an asset. (but you’ll lose the ability to track each
> Voucher due separately since they are ‘already paid’ within GnuCash)
>

I don't particularly care about tracking due expenses from the rest of A/P.

Thanks for your suggestions!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Modelling employee expenses

[Matthew Pounsett]

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 tie the
>> two together.
>>
>
> Matthew,
>
>   Why not enter employees as vendors and treat them as any other vendor? As
> a sole practitioner professional services provider I don't have employees
> (tried that a couple of times years ago; didn't work well either time) so I
> may be missing something in your situation.
>
> Because I'd like to treat the actual vendors as the vendors in this
situation.  I don't see how I could enter an employee expense voucher as a
vendor bill, and then still track a vendor bill with the correct vendor
attached to it.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Modelling employee expenses

[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, post, pay the employee.  However, I have
two problems with that:
1) the voucher line item descriptions aren't included in the split
descriptions in the expense accounts, so it's hard to trace an item back to
its purpose from looking at an expense ledger
2) there's no easy way to deal with taxes in the employee vouchers, so my
purchases tax is unaccounted for

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.

My first thought was that employee expenses are obviously a liability,
however that ends up balancing a liability against a liability
(Liabilities:Employee Expenses vs. Liabilities:Accounts Payable).  Perhaps
an asset makes more sense?  Balance Liabilities:Accounts Payable against
Assets:Employee Expenses, and then pay bills out of that asset?

While I'm certain using an asset would work, I'm curious how do other
people do this?

Cheers,
   Matt Pounsett
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] help setting accounts to track contributions

[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 sure that we both are contributing
>> equally to house expenses.
>>
>> How should I set up the contribution? Under what main account type should
>> it be? Any recommendations?
>>
>> I am going to suggest something more straight forward than treating
> contributions as "income", less distorting to what the situation is.
> Imagine that this were an ordinary (business) partnership, income,
> expenses, and partner's "drawings" or "contributions" (partner's drawing
> accounts are under equity, representing each partner's investment in the
> enterprise). In other words, you can look in a standard accounting text
> under "accounting for partnerships".
>

This doesn't sound straightforward at all.  What's complicated about
treating joint contributions to the household coffers as "income" to the
household?  Treating that income as ever-increasing equity would confuse
P and cashflow calculations, wouldn't it?


> OK, this is a special sort of partnership that only has expenses, no
> income. So the drawing account of each partner will only show
> contributions. Going to be very easy to see if the total contributions are
> equal or not.
>
> In other words, a funny set of books, in effect just "expenses" and
> "equity" trees with meaningful content. You can leave the top level parents
> "assets", "income", and "liabilities" in there, but usually these would
> have no contents. Or perhaps because of how you run your household, they
> might. For example, could be a "cookie jar" for small amounts of cash held
> on hand, so something under assets. Or there might be a situation where one
> partner pays a large bill but that partner's contributions are already
> higher. So treat that as a loan to the partnership and now something under
> "liabilities"
>

It seems to me that a household is just as likely to have liabilities and
assets.  In our case, there are credit cards, the mortgage, and the house.
There might also be a car, or any number of other assets jointly owned.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 the budget view. When I'd entered
> my budgets for "food" and "drink", the total dining budget was the total
> sum, as expected. However, I clicked on the value for "Dining", by
> mistake, and the editable text box showed up, and now it's become an
> editable field in black. The value is no longer updated as the sum of
> "food" and "drinks". Is there some way to revert it to the original "sum
> of all sub accounts" behaviour?
>
> I haven't done the transition to 3.0 yet, but in 2.x this can be cleared
by deleting any text in the field.
Double-click the field, make sure the complete number is selected, hit
Delete (or Backspace) and then Enter.

If that doesn't work, then as David says it's probably a bug you should
file.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 accounts sqllite db, but 21 gnc-*-sql.cpp files in the SQL
back-end code, and not all of those are created.  That's an odd mismatch
that needs to be accounted for.  Also, in the database there are no foreign
keys defined, which means it's going to be difficult to confirm all of the
expected relations.  That combination of facts makes for a really difficult
job reverse-engineering the schema by trial and error.   A pointer to the
documentation that the developers are using when they do their work would
make the whole thing a lot easier.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 appropriate ODBC module for your SQL
> engine of choice and connect to it with Libre/OpenOffice, Microsoft Access,
> or some similar tool with a custom report writer or your favorite
> programming language’s SQL interface (e.g. DBAPI for Python).


Is there some clear documentation of the SQL schema somewhere?  I had a
look through the gnc-*-sql.cpp files, but it's not the most transparent
description of a database that I've ever read. :)   I was considering
putting together a set of Python/SQLAlchemy classes that implement the
object-data mapping, and would be happy to contribute it back to the
project, if people thought that'd be useful.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Compiling -DWITH_GNUCASH=NO

[Matthew Pounsett]

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 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 cost of moving away from scheme as reporting engine unfortunately as
> that
> would not be portable...
>
>
> lua maybe?  It seems popular and portable.. and it's already on my personal
> education roadmap. :)
>
>
> Apple’s rules for iOS include *no interpreters*. That means no Guile, no
> Python, no Lua, no Ruby, no Javascript.
>

That's a shame.  But doesn't that pretty much rule out having an easily
expandable reporting engine on iOS?


>
> BTW, no, lua isn’t particularly popular: https://insights.
> stackoverflow.com/survey/2017#technology
> https://isocpp.org/files/papers/CppDevSurvey-2018-02-summary.pdf
>
> That shows percentage of all languages, not embedded
scripting/configuration languages.   And speaking from recent personal
experience, lua seems to be gaining in popularity faster than anything else
I've noticed for that purpose.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Compiling -DWITH_GNUCASH=NO

[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 cost of moving away from scheme as reporting engine unfortunately as
> that
> would not be portable...
>

lua maybe?  It seems popular and portable.. and it's already on my personal
education roadmap. :)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Wrong balance after entering transaction after import

[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 entered a $60 payment. Instead of the balance going down by $60
> it
> went up by $1633.35. Why?
> 


 You've entered the date as the 21st.  Once that is properly sorted by
date, the transaction will move up several slots in the register to be just
after "from Linda for airport parking."  Once that re-sort takes place,
listed balance will make sense.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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:Investments:RIF:MoneyMarket1
> Assets:Investments:RIF:Cash
> etc.
>

Mine are similar, without the cash account.  Looks like we're modelling
this part the same way.


>
>
> The offset account can't be a liability - that would double the impact of
> the withdrawal and screw up your balance sheet. It pretty much needs to be
> either an Equity or an Expense account. As I think about it more, there is
> a certain logic to the latter, since it was originally Income.



I see what you mean about Liability.. you're right, that wouldn't work.
Last night as I was thinking about this more, it occurred to me that a
non-taxable Income account would probably work best to balance out taxable
income.



> I think if your employer contributes to your RRSP or a fund or other
> instrument within it, that probably needs to be dealt with as Income. Also,
> it may count as a taxable benefit.


My recollection from the last time an employer did RRSP matching for me was
that it was tax deferred, just like any other RSP contribution.   But, I
was talking about self-contributing direct from payroll, which can happen
pre-tax (pre-withholding).
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: How to deal with RRSP's (Canada)

[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:Current Assets:Chequing Account$5,000
> Assets:Investments:RRSP$5,000
>
>
RRSPs are investments–typically mutual funds–and not savings accounts (at
least, every RSP account I've ever had has been presented that way: as X
units worth $Y per unit).  So, when I buy in to my RRSPs it shows in my GC
books as a purchase of shares of a mutual fund.  Transfers out as a sale of
shares.



> Withdrawal is more complex, because you have to show Income, Withholding
> Tax, the receiving Account, and the RRSP account, so using an Equity
> account for RSP/RIF withdrawals is needed to balance, like this:
>

It only needs to be more complex if you're trying to use GC to calculate
your tax for you.  If that's the case, then there's additional complexity
on both the purchase and sale of RRSP shares.  On purchase, you need to
reduce your income, but I'm not sure what that would be balanced against.
The most likely prospect seems to me to be a liability, probably.   On sale
there's no withholding, or any immediate tax activity.. that all comes at
the end of the year when you calculate your taxes.  This makes sense if you
think about the fact that (assuming you purchase RRSP shares from out of
your assets) there was no negative change to withholding when you bought
the RRSP shares in the first place.  That only occurs if your employer is
buying shares on your behalf pre-tax, which will still work out, because
that immediately reduces whatever you would have put in your income
(salary) account.

So on purchase of RRSP shares you'd reduce your effective income and
increase an offset (liability?) account.  On sale, do the reverse until
your chosen offset account hits zero, and then any other withdrawls are new
income (gains on the investment).  I believe the rest should come out in
the wash (tax forms).  The only question in my mind is what to balance the
income account against.. and I'm afraid for that I only have guesses.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Printing Hard Copy

[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 Transaction
Journal ledger?

OP, I think the answer is, "you can't."   At least not directly from within
GnuCash.  The best I've ever found is to export an account to CSV, hide or
delete the columns I'm not interested in, and print that.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Church Use of GNUCash

[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. Assets:Current Assets:Chequing Account:Organ Fund
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: How to deal with the cash flow and the credit card.

[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 I
wouldn't use Scheduled Transactions for that.  I'd just create a
future-dated transaction in the register (and do something to mark it so
that it still stands out when it's no longer in the future).  Using the
Scheduled Transactions editor for something you only want to happen once is
a lot of unnecessary overhead.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled transactions

[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 change the dates of the scheduled transactions
> or the number of days to create in advance. That is a one-by-one operation.
> I'm looking for a way to tell GnuCash to go ahead and process all of the
> scheduled transactions early.
>
> I don't think there's a way to do precisely what you're asking.  My
suggestion would be to tell GnuCash to Create in Advance by a week or so.
Then, for CC payments for example, if you make them a few days early just
change the date of the transaction that GC creates.  I do this myself for
regularly occurring transactions that don't have predictable dates.  For
example, my Internet Service Provider for some reason doesn't bill on
exactly the same date every month, and it can be +/-5 days from the average.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: budget

[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 expense in 1 month, it is not as good because to make it work
> out over the year, you need to budget the expense over 12 months. On the
> other hand, if you think of the budget as "put money away for the upcoming
> trip", then it does work out. Put $200 per month into savings and then when
> it gets big enough, spend it on the trip.
>
> I've taken a more direct tack with envelope budgeting.   For example,
assuming the savings account Assets:Current Assets:Savings Account
represents a real bank account, I have also created Assets:Current
Assets:Savings Account:Travel, and have a monthly auto transaction that
transfers money to the Travel subaccount from its parent account.  This
goes in my budget as a monthly transfer (stashing cash in an envelope) and
then comes out in large chunks as its spent on trips.

This also works well with other expense types where I have to make
absolutely certain that an amount of money in my accounts is clearly
"reserved" for a specific purpose, but where there isn't a regular monthly
expense (e.g. property taxes, which are billed six times a year here, at
apparently irregular intervals).

In the accounts list, comparing the "Balance" to the "Total" columns shows
the difference between what's in the real bank account vs. what's
"unreserved" (or, not transferred to a subaccount).

The only thing I haven't worked out is Present is to Total as  is to
Balance.  This would be helpful for distinguishing the two when
future-dated transactions are in use.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Window location

[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 think
probably every single other window, but I'm allowing that maybe there's
something I haven't noticed) opens at the 0,0 desktop coordinate (top
left).  This is way out of my eye line.  And yes, I'm aware this is a first
world problem of the highest order.  :)

Is this a problem anyone else even notices?  If not, I'm fine to suck it up
and deal, but it would be a huge convenience to me if gnucash was able to
save the locations of other windows, or alternatively, open them in the
vicinity of the parent window.

My C knowledge is fairly rudimentary, but I'm a competent programmer in a
few other languages.  I'd be happy to help out with a feature if that seems
like a thing I could reasonably help with, or if the core team doesn't
think it's high priority enough to put on the future feature list.

- Matt
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Version Migration

[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 just pointed out that GnuCash doesn’t create backups with the
> SQL backend the way it does with the XML one.
>
> As always the user should have automatic backups to separate media,
> including off-site, regardless of backend. With SQLite3 that can be done
> with a simple file copy as well as the usual SQL dump that one might use
> with a server database.
>
> Indeed.  There are all sorts of ways that backups can be accomplished.. I
pointed out a zero-effort option which seems to work reliably, but that
doesn't stop people from doing an SQL dump, or manual copy to a USB key or
offsite, or whatever.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Version Migration

[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
> may be high or low.
>
> I've done a few spot-checks for consistency and never run into a problem.
I don't know this for certain, but it looks as if GnuCash is wrapping each
update in a transaction.  If it is doing that, it would ensure that the
data written to disk is never inconsistent.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

High-balance reporting?

[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 reports, but before
I dug into that I thought I'd ask if anyone else has already solved the
problem.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Version Migration

[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'm accomplishing that part by writing the sqlite3 file to Dropbox, which
provides file history (so I can roll back if necessary) and takes care of
replicating the data between my desktop and laptop, provided I'm careful
never to run the app in both places at the same time.

The backups could be automatically accomplished with other storage that
provides a versioned backup... MacOS's Time Machine would do the trick, for
example.  ZFS doesn't work particularly well on Linux (it's a Solaris and
BSD thing), but I imagine there's some other option for obtaining snapshots
there, and likewise I assume Windows would have a similar feature.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.