2017-09-03 GnuCash IRC logs

00:21:52 *** jralls_afk has joined #gnucash
00:24:54 *** jralls_afk has quit IRC
01:23:09 *** jralls_afk has joined #gnucash
01:26:23 *** jralls_afk has quit IRC
01:32:46 *** Mechtilde has joined #gnucash
02:21:47 *** pilotauto has joined #gnucash
02:24:25 *** jralls_afk has joined #gnucash
02:27:30 *** jralls_afk has quit IRC
02:44:54 *** hoijui has joined #gnucash
03:15:37 *** fabior has joined #gnucash
03:25:40 *** jralls_afk has joined #gnucash
03:28:46 *** jralls_afk has quit IRC
03:32:33 *** pilotauto has quit IRC
03:42:04 *** jotrago has quit IRC
03:46:03 *** jotrago has joined #gnucash
04:26:55 *** jralls_afk has joined #gnucash
04:30:03 *** jralls_afk has quit IRC
05:18:05 *** Aussie_matt has joined #gnucash
05:41:01 *** quazgar has joined #gnucash
05:42:16 <quazgar> warlord: Thanks again for yesterday's help on AR/AP. I read up on the business features and think they should work fine. I will add a warning to the German gnucash wiki as soon as my wiki account has been approved to prevent others from making the same mistakes.
05:46:13 *** jeff has joined #gnucash
05:57:16 *** quazgar has quit IRC
06:05:26 *** Mechtilde has quit IRC
06:11:37 *** Mechtilde has joined #gnucash
06:28:13 *** jralls_afk has joined #gnucash
06:31:18 *** jralls_afk has quit IRC
06:35:27 *** User has joined #gnucash
06:39:24 *** fabior has quit IRC
06:40:48 *** fabior has joined #gnucash
06:42:55 *** jotrago1 has joined #gnucash
06:43:55 *** jotrago has quit IRC
06:43:56 *** jotrago1 is now known as jotrago
06:45:33 *** fabior has quit IRC
07:00:27 *** fabior has joined #gnucash
07:27:02 *** fabior has quit IRC
07:29:37 *** jralls_afk has joined #gnucash
07:32:50 *** jralls_afk has quit IRC
07:43:02 *** jeff has quit IRC
07:47:23 *** patb has joined #gnucash
07:49:02 <patb> Hi, I have a problem with gnucash where I can't see one of my sub-accounts. I can see it in the 'edit accounts' dialog but it does not appear on the 'Accounts' tab.
08:02:53 *** Aussie_matt has quit IRC
08:26:12 *** wget has quit IRC
08:26:38 *** wget has joined #gnucash
08:29:49 <gjanssens> patb: Where do you have an "Edit Accounts" dialog ? I only have "Edit Account" for one account at the time ?
08:30:39 <gjanssens> Anyway, try View->Filter by...' on the Account Hierarchy page and tick "Show Hidden Accounts" in the "Other" tab.
08:30:49 <gjanssens> Does your account appear now ?
08:30:50 *** jralls_afk has joined #gnucash
08:34:00 *** jralls_afk has quit IRC
08:53:46 *** GiGa has joined #gnucash
08:54:31 <GiGa> Hello, I'm new to GnuCash, trying to get my head round it all
08:54:49 <GiGa> I'm hoping to use it to run my youth group's accounts
08:55:17 <GiGa> and was wondering if I could get it to export reports in a particular layout, which is how my (volunteer) auditor expects them
08:58:19 <GiGa> Normally I have to hand something like this in for auditing:
08:58:19 <GiGa> https://drive.google.com/file/d/0B7CaVvh5ev8UdkJUTVZuUjBYTGM/view?usp=sharing
08:58:29 <GiGa> but I've not seen how to do that yet
08:58:42 <GiGa> Are you able to offer any advice please? Thanks
09:03:06 <gjanssens> GiGa: gnucash will not output your transactions like that. If your auditor insists on that exact format you'll have to post-process the gnucash output in Excel or Libreoffice Calc
09:03:32 <gjanssens> On the other hand al the information presented on your example can be recorded and reported in gnucash with ease
09:04:34 <GiGa> gjanssens, importing it sounds potentially useful
09:04:55 <gjanssens> If you properly enter each line in your example as one transaction with the proper splits for your right-hand side details you can just run a transaction report (in multi-split view) to report the requested details
09:05:14 <GiGa> I'm assuming I'll need to rename the accounts along the top to "INCOME:Subs" and split out the income / expenses?
09:05:37 <GiGa> gjanssens, I think I understand what you mean, let me give that a go
09:05:49 <gjanssens> GiGa: good luck!
09:06:52 <GiGa> What would be the most suitable report to give my auditor? It needs to show a document number, which I'm assuming I can use the "NUM" column on each transaction ?
09:09:50 <GiGa> OK, I'm apparently not understanding the split bits and pieces
09:16:11 <GiGa> Ah, OK
09:17:11 <GiGa> so if I have an expenses account called "Cash In" that is the money I'm handed on the night
09:17:53 <GiGa> I then create a split transaction for all of the other accounts, and essentially transfer from the "Cash In" expenses account to the relevant income account?
09:23:58 *** Mechtilde has quit IRC
09:25:23 <GiGa> gjanssens, have I understood that correctly?
09:32:10 *** jralls_afk has joined #gnucash
09:35:18 *** jralls_afk has quit IRC
10:33:24 *** jralls_afk has joined #gnucash
10:33:56 <patb> gianssens - yes the account was hidden! I don't know how that happened. Yes I meant the 'Edit Account' dialog available off the context menu. Thank you very much.
10:34:16 <GiGa> I'm liking this budget feature a lot
10:36:30 *** jralls_afk has quit IRC
10:43:05 <patb> gjanssens: yes the account was hidden! I don't know how that happened. Yes I meant the 'Edit Account' dialog available off the context menu. Thank you very much (got yr name wrong earlier)
11:19:24 *** hoijui has quit IRC
11:29:23 <gjanssens> patb: no problem and glad you got it fixed
11:29:30 *** Mechtilde has joined #gnucash
11:30:12 <gjanssens> GiGa: no that's not correct.
11:30:58 <gjanssens> Cash In would be an Asset account (like the default Cash in Wallet account)
11:31:19 <gjanssens> The rest is correct
12:29:16 *** jeff has joined #gnucash
12:43:32 *** Jacques has joined #gnucash
12:50:10 *** jeff has quit IRC
12:51:24 *** Jacques has quit IRC
13:09:06 <GiGa> gjanssens, sorry for delay, been playing with it on and off
13:09:20 <GiGa> gjanssens, just found the same, but thanks for confirming
13:12:27 *** GiGa has quit IRC
13:12:40 *** patb has quit IRC
13:17:25 *** User has quit IRC
13:50:14 *** PaceyIV has joined #gnucash
13:52:46 <PaceyIV> Hi, I'm new on GnuCash. I cant figure out how to manage correctly salary and taxes. I understand how to use split transaction and manage Income:Salary, Assets:Checking and the various Expenses:Taxes.
13:53:40 <Mechtilde> Did you read "tutorial and concepts" PaceyIV
13:54:03 <PaceyIV> I have some trouble with date. I receive the salary for December on January of the next year
13:54:46 <PaceyIV> so I can't undestand how to manage fiscal year with the day I reaceave the last salary
13:55:32 <PaceyIV> Yes, I've read tutorial and concepts. I've understood how to split the transaction for salary from it
13:56:00 <Mechtilde> you have the receivables in the old year
13:56:22 <Mechtilde> and got it paid the next year
13:57:06 <Mechtilde> so you have different days for the receivables and the payment
13:57:16 <PaceyIV> I don't understand. English is not my first language, also economy :)
13:58:02 <Mechtilde> what is your favourite language
13:58:10 <PaceyIV> Italian
13:59:47 <Mechtilde> did you read the Italian translation
14:00:10 <Mechtilde> Guida ai concetti
14:00:26 <PaceyIV> yes, it's not compleated but very usefull
14:01:44 <Mechtilde> maye it can help to understand
14:02:23 *** frakturfreak has joined #gnucash
14:02:24 <PaceyIV> If I enter the transaction on 10-January so I can reconcile with my bank report, I can't understand I can I consider this entry for the previous year instead of the current year
14:23:51 *** To7 has joined #gnucash
14:39:23 <gjanssens> PaceyIV: you are doing cash based accounting while you want to do accrual based accounting
14:40:10 <gjanssens> cash based accounting simply follows the money flows: you receive a payment on Jan 10, so you enter the whole transaction on Jan 10
14:40:21 <gjanssens> However the payment is for a service rendered in December
14:40:47 <gjanssens> In accrual based accounting you'd enter a transaction for that service in December already
14:42:02 <gjanssens> You'd enter a transaction for income:salary/liability taxes to Assets/Receivable income
14:42:10 <PaceyIV> a date for cash and a date for taxes etc... ok, but how it is possibile to manage on gnucash
14:42:32 <gjanssens> Then when you get paid you add a second transaction from Assets:Checking to Assets:Receivable
14:42:47 <PaceyIV> the date is common for all the money flow in the split transaction
14:43:30 <gjanssens> I just told you how to do it. You enter 2 transactions, each recording the event that happened at that moment
14:44:03 <gjanssens> The first event is that you "charge" your company for your salary, but at that moment it's not payed yet
14:44:17 <gjanssens> The second event is that what the company owes you actually gets paid
14:44:52 <PaceyIV> I am the employ
14:48:19 <gjanssens> Do you mean you are both the employer and the one getting the salary ?
14:49:30 <PaceyIV> No, I use gnucash for my personal financial. I'm not a society.
14:50:45 <PaceyIV> I'm trying only to manage the money I received from my company. They pay for me some taxes and I receive only the net salary, but I'd like to manage also the taxes in gnucash
14:52:34 <PaceyIV> When I receive salary my back receive only the net salary so I create a transaction on this date, but I move money to tax account and I increase the salary to the gross value that I see only in the report that my company give me with the money
14:54:09 <gjanssens> You continue to skip the first step.
14:54:22 <PaceyIV> which one?
14:54:25 <gjanssens> When you have worked a month for the company, the company *owes* you something
14:54:44 <gjanssens> You have to record that first. It's what is written on your salary note
14:55:13 <gjanssens> The second step is that the company *pays* you what they owe you, your net salary
14:55:26 <PaceyIV> Ok, I can record it on 31 december, but where I put it?
14:55:36 <gjanssens> Put what ?
14:55:52 <PaceyIV> the money the company owes me
14:56:00 <PaceyIV> I have to create an account for this?
14:56:23 <gjanssens> Yes. You can call it what you like, usually it's called "Receivable" or something similar
14:56:36 <PaceyIV> and is an entrance?
14:57:04 <gjanssens> And normally something someone else owes you is an asset, so you create a new asset account under your assets.
14:57:20 <gjanssens> What is an "entrance" ?
14:58:07 <gjanssens> According to the gnucash translation an "Asset" is called "Attività" in Italian
14:58:33 <PaceyIV> my mistake, incoming
14:58:51 <PaceyIV> in Italy Incoming is Entrata
14:59:00 *** Jacques has joined #gnucash
15:00:33 <gjanssens> No your gross salary is the income. From that your taxes will be taken and the net salary is what the company still has to pay you, so the Receivable part
15:01:36 <PaceyIV> so, on 31 december Activity:Receivable receive maney from Incoming:Salary and pay taxes to Expense:Taxes. On 10 January my Bank account receive money from the Asset:Receivable
15:02:46 <gjanssens> Yes, except I believe taxes are a liability rather than an expense, something you owe the state
15:02:51 <PaceyIV> Asset:Receivable is only a place to park temporally my money and split the transaction in two operation with different date
15:03:19 <PaceyIV> ok ok... I confuse the word from Italy to English
15:03:31 <gjanssens> That's a backward reasoning but ok
15:03:58 <gjanssens> You park what you are due, but that didn't get payed to you yet
15:04:16 <PaceyIV> yeah... now I undestand
15:04:25 <gjanssens> Great :)
15:04:37 <gjanssens> That's the basis of accrual accounting
15:05:22 <PaceyIV> I don't remember this concept from the gnucash guide. I've lost something?
15:06:14 <gjanssens> It's explained in the business chapters as that's where it's usually used
15:06:38 <PaceyIV> for society?
15:06:48 <gjanssens> And you are doing it manually because gnuash doesn't support payroll, while the business features do this for you each time you create a bill or invoice
15:06:58 <PaceyIV> I skip that part, I thought was for society only
15:07:24 <gjanssens> It's uncommon for people to use accrual accounting for their personal finances
15:07:56 <gjanssens> But since you want to track taxes in the proper year, I explained the principles to you.
15:10:05 <PaceyIV> in the gnucash guide I've seen how to split the transaction to manage the taxes for salary, so I start to learn how this can work. before I manage only my net salary
15:10:53 <PaceyIV> yeah.... tanks for your help
15:10:59 <PaceyIV> thanks
15:11:09 <gjanssens> You're welcome
15:15:05 <PaceyIV> last problem. If I start traking money from 1 January 2017 how should I manage the incoming from December 2016?
15:15:35 <PaceyIV> I can create an account Salary2016 that I use only for this transaction without taxes?
15:16:03 *** Mechtilde has quit IRC
15:16:31 <gjanssens> Simply create an opening balance transaction from your Receivable account to Equity:Opening balances
15:16:42 *** Mechtilde has joined #gnucash
15:17:16 <PaceyIV> you right, sorry for the stupid question
15:17:27 <gjanssens> no problem :)
15:18:35 <PaceyIV> I think I will read also the bussines section
15:25:05 *** Mechtilde has quit IRC
15:25:42 *** Jacques has quit IRC
15:33:03 *** jeff has joined #gnucash
15:38:10 *** jralls_afk has joined #gnucash
15:41:13 *** jralls_afk has quit IRC
16:02:28 *** User has joined #gnucash
16:29:55 *** frakturfreak has quit IRC
16:39:24 *** jralls_afk has joined #gnucash
16:42:35 *** jralls_afk has quit IRC
17:07:51 *** PaceyIV has quit IRC
17:10:02 *** jeff has quit IRC
17:40:39 *** jralls_afk has joined #gnucash
17:43:44 *** jralls_afk has quit IRC
17:48:42 *** Cuare has joined #gnucash
18:41:54 *** jralls_afk has joined #gnucash
18:45:02 *** jralls_afk has quit IRC
18:52:47 *** pilotauto has joined #gnucash
19:21:27 *** gjanssens has quit IRC
19:43:08 *** jralls_afk has joined #gnucash
19:46:12 *** jralls_afk has quit IRC
20:44:21 *** jralls_afk has joined #gnucash
20:47:31 *** jralls_afk has quit IRC
20:55:53 *** bertbob has quit IRC
21:44:40 *** bertbob has joined #gnucash
22:15:27 *** User has quit IRC
22:45:39 *** jralls_afk has joined #gnucash
22:49:34 *** jralls_afk has quit IRC