[GNC] Duplicate Transactions

[Jesse MacDougall]

Hi there, I am doing some bookkeeping and I went to add two new
transactions by right clicking a current transaction and selecting
duplicate traction.

I changed the date and added amount but do not see the transactions in the
account GL.  However, the amounts did get posted as I see the total dollar
amount has changed.


Question:
1) how do I find the two transactions so I can delete them?

2) Is there a better way to make a new transaction in an account GL
instead of duplicating a transaction and changing the data?

Merci,



-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] Eliminate Manual Download of Transaction

[Jesse MacDougall]

I have downloaded OFX file from my bank and credit cards.
Is there a way I can automate manually downloading these files? I only File
- Import - Import options.  The Objective is to have to download the QFX
files each month and auto import them.

I see Tools - Online Banking Setup - and see Start AqBanking Wizard. I
select OFX-DirectConnect backend. I type in Royal Bank.  Royal Bank America
shows.

Am I on the right track?

Merci

[image: ofrxDirect.png][image: aqBanking.png]

-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] PDF creation option

[Jesse MacDougall]

Good question! I want to achieve a similar out come. How can we add images
and or css to the reports? Is this possible...?

On Wed., Feb. 2, 2022, 16:33 Jed Taylor,  wrote:

> I've created some .pdfs of P&L reports, and set the report to use the
> two-column layout.  I just discovered this option doesn't size the output
> to
> the printed page, so the far right totals (the number I'm most interested
> in
> - the net P/L for the period) are missing.
>
>
>
> Changing the report layout to a single column so that the expenses are
> under
> the income rather than beside them solves this issue, although there's
> next-to-no margins on the page.
>
>
>
> Any suggestions as to how to produce good-looking reports from GnuCash?
>
>
>
> 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.
>
___
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] Vanguard OFX Access

[Jesse MacDougall]

Did you try to import it? I did, works for me.  Was a nice surprise =)

On Fri, Jan 28, 2022 at 9:47 AM Tom Teixeira 
wrote:

> On 1/21/22 6:08 PM, Kalpesh Patel wrote:
> > Sadly Vanguard does not offer OFX formatted download. They only provide
> QIF,
> > in one account or individual mutual fund accounts,  or CSV format - very
> > limited formats. Even with QIF format it is a hit or miss in importing to
> > GNC and CSV formatted requires good deal of post-processing
> >
> My choices for downloading activity from Vanguard are "Quicken: All
> funds to a single account (recommended)" which gives me an
> OfxDownload.qfx file, not a QIF file. I don't think there's anything
> particularly special about my Vanguard 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.
>


-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] How to properly import a csv with the correct settings.

[Jesse MacDougall]

I found it easier to download in QFX format imports fine into gnu cash for
me

On Thu., Jan. 27, 2022, 19:56 ,  wrote:

> It looks OK but the test is how it actually imports.
>
> If you have not imported to that set of books previously the import
> procedure
> will run a dialogue to match the entries in the Account column to internal
> accounts. AFAIK that dialogue has a button which will allow you to create
> new
> accounts where necessary but it has been a long time since I have had to do
> that. Many of the dialogues in GnuCash are not modal, i.e. they do not
> stop you
> from performing other actions while they are open unless absolutely
> necessary so
> it is likely you could go to the Account tab and create a new account from
> there
> anyway. The drop down lists in the dialogues are normally populated when
> they
> are called so the new account should then appear as an option to be
> matched.
> David Cousens
>
>
> On Thu, 2022-01-27 at 21:24 -0600, W Velishek wrote:
> > Hello All,
> >
> > I was using QuickBooks Online and exported the information to Excel
> > Spreadsheets. I had someone clean up the Spreadsheet and convert it to
> > .csv . Now I am trying to import the csv into GnuCash. I have previous
> > GnuCash files set up but I always messed them up. So Importing this csv
> > into a fresh GnuCash file. I chose the Business accounts template in
> > GnuCash but no other custom accounts have been added. The csv that I
> > want to import has 99% all of the business transactions from 2020 until
> > recently so if I can get this imported properly there will be very
> > little else for me to import.
> >
> > Included is a screenshot of the import process.
> >
> > -Please let me know what I have correct and what I have wrong or
> incomplete.
> >
> > -When I am importing this csv and I have to match accounts in the csv to
> > accounts in GnuCash will I have the opportunity to create a new account
> > or new sub-account right then during the import process?
> >
> > 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.
>
> ___
> 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] Accounting Question re Balance Sheet

[Jesse MacDougall]

I Paul, each of the properties are to be listed in the chart of accounts so
that your balance sheet is complete and accurate.  Right now it's cloudy.
So let's polish it up.
The tax is (Sale Price - Cost Of Asset ) * 50%, that is all CRA cares
about.  Bookkeeping works out to a difference in the cost of the asset and
sale price -50%,  The difference would go to revenue if flipping properties
was your main business but its not so, this isn't a business the revenue
would go to due/to from Owner
The Due/ To/From is that accounts where your like "ahh...the puzzle piece
goes here".

Hope this helps



On Thu, Jan 20, 2022 at 11:56 AM  wrote:

> This isn't really a GnuCash question, but I thought I might ask you guys
> anyway as there's a broad variety of skills and experience here.
>
>
>
> Situation: a relative owns a house on a six acre property, plus several
> adjacent properties she's collected over the years. Under Canadian tax
> rules, the house and some of the lot it's on are tax exempt. The other
> properties are taxable for capital gains. They will be sold over the next
> years, one at a time to keep marginal rates down. There will also be
> significant sales expenses (commissions, surveyors, .) associated with each
> sale.
>
>
>
> My question is about how to structure this tax and sales costs liabilities
> in the Chart of Accounts, and thus the balance sheet.
>
>
>
> It seems to me sensible to have the properties in Assets*, and the expected
> Sales Fees / Taxes in Liabilities*. Then when a property is sold, both
> assets and liabilities are reduced by the expected values, and the
> differences between the expected and actual values are booked as Income or
> Expense (Net gain / loss on land sales?).
>
>
>
> This approach makes the Balance Sheet reasonable every year, but the Income
> Statement only shows the adjustment, not the total funds in and out due to
> the sale.
>
>
>
> I've tried some alternatives too, but not having the properties as assets
> makes the Assets side of the balance sheet look silly, whereas not having
> the expected taxes / sales costs in Liabilities means that a sale triggers
> a
> huge, unexpected expense in the Income Statement without any corresponding
> income to cover it.
>
>
>
> Am I missing some cleverer way to do this? Is there a GAAP approach for
> this?
>
>
>
> Thanks for any suggestions,
>
> Paul
>
>
>
> *I know "real" books keep only the book values of these assets and tax
> liabilities, but as this is a person rather than a company, and the reports
> need to make sense to a non-business person, we use current market values
> in
> these accounts, and annually update the expectations.
>
> ___
> 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.
>


-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] OneDrive and GnuCash

[Jesse MacDougall]

Are you running gnu cash locally and the data from onedrive?
I have not used one drive personally but I did use Quickbooks to Dropbox in
real time and that was total fail.

On Tue, Jan 18, 2022 at 10:52 AM David Carlson 
wrote:

> Are there any GnuCash users that store their data files in One Drive?
>
> Are there any issues slow response or keeping a few weeks of backup and log
> files?
> ___
> 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.
>


-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] Period Ends

[Jesse MacDougall]

Thanks for clarifying that Gyle.
Interesting. Yes definitely never post to past periods.  Move forward.


On Fri, Jan 7, 2022 at 8:07 AM Gyle McCollam  wrote:

> Jesse, Unfortunately, Gnucash does let you post to closed periods.  This
> will mess up the closing entry, which will need to be adjusted.  I agree
> you shouldn't post to closed periods, however the program does allow and
> doesn't warn if you do it.
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.comemail
> ------
> *From:* gnucash-user 
> on behalf of Jesse MacDougall 
> *Sent:* Friday, January 7, 2022 10:49 AM
> *To:* Mike Stillingfleet 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Period Ends
>
> 2) all your data goes in one file KISS
>
> Period ends are for security so that entries can not be posted to once
> period end processes are complete. For example in public accounting we
> close off year end files once our year end work is complete. All statements
> match bank account and. credit cards there the file is complete
>
> Another reason for year end close is so someone doesn't go back and make
> changes to work we already concluded is complete.
>
> On Fri., Jan. 7, 2022, 01:41 Mike Stillingfleet, <
> mikestillingfl...@fastmail.co.uk> wrote:
>
> > Dear All,
> >
> > Several years ago I attempted to close off at end of year and it didn't
> > end well.
> >
> > I am revisiting this topic and trying to work out if there is any benefit
> > to it.
> >
> > 1. My period runs 6/4/ to 5/4/ so on a calander basis therefore I
> > believe I should be choosing relative for period start and period end.
> >
> > 2. I currently have access to all my transactions which is very useful.
> If
> > I understand the process correctly to maintain access to these
> transactions
> > I need to create separate files for each year prior to doing the period
> > close. So for future searches I would need to work through several files.
> >
> > 3. If I have set the accounting periods and I have control over the date
> > ranges in other reports I am not clear as to what advantage I gain by
> > closing prior periods. When I used Quicken if I remember correctly
> closing
> > a period was part of the reconciliation process. However, transactions
> were
> > not zeroed as far as I remember and so that could still be viewed.
> >
> > Any advice / comment would be welcomed.
> >
> > --
> >   Mike Stillingfleet
> >   mikestillingfl...@fastmail.co.uk
> > ___
> > 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.
>


-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] Period Ends

[Jesse MacDougall]

2) all your data goes in one file KISS

Period ends are for security so that entries can not be posted to once
period end processes are complete. For example in public accounting we
close off year end files once our year end work is complete. All statements
match bank account and. credit cards there the file is complete

Another reason for year end close is so someone doesn't go back and make
changes to work we already concluded is complete.

On Fri., Jan. 7, 2022, 01:41 Mike Stillingfleet, <
mikestillingfl...@fastmail.co.uk> wrote:

> Dear All,
>
> Several years ago I attempted to close off at end of year and it didn't
> end well.
>
> I am revisiting this topic and trying to work out if there is any benefit
> to it.
>
> 1. My period runs 6/4/ to 5/4/ so on a calander basis therefore I
> believe I should be choosing relative for period start and period end.
>
> 2. I currently have access to all my transactions which is very useful. If
> I understand the process correctly to maintain access to these transactions
> I need to create separate files for each year prior to doing the period
> close. So for future searches I would need to work through several files.
>
> 3. If I have set the accounting periods and I have control over the date
> ranges in other reports I am not clear as to what advantage I gain by
> closing prior periods. When I used Quicken if I remember correctly closing
> a period was part of the reconciliation process. However, transactions were
> not zeroed as far as I remember and so that could still be viewed.
>
> Any advice / comment would be welcomed.
>
> --
>   Mike Stillingfleet
>   mikestillingfl...@fastmail.co.uk
> ___
> 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] Tax question - gross income for the year

[Jesse MacDougall]

Your income stamement is where u want to look

On Wed., Jan. 5, 2022, 18:47 Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> Don't use the transaction report. Use the P&L or Income Statement. (same
> report, different names)
>
> If you are working on a cash basis, you'll have to make adjusting
> entries or else don't post invoices till you receive payment.
>
> If you are on an accrual basis, then no adjusting or delayed posting is
> necessary. You post when the work is done or when the goods change hands.
>
> Regards,
> Adrien
>
> On 1/4/22 6:06 PM, Daffy Duck wrote:
> > Hello,
> >
> > I'm having an issue in transaction report in easily seeing gross income
> > for the year.
> >
> > Specifically:
> >
> > 1. I have Income:Sales and when I do an invoice, I direct income to go
> > there.
> >
> > 2. Sometimes clients reimburse me for postage charges, so that does not
> > go to income:sales but is in expenses:reimbursed expenses
> >
> > 3. Many times at the end and the beginning of the year, an invoice is
> > not closed, so an invoice I opened 11/20 may still be being paid
> > throughout early 2021.
> >
> >
> > What is the best way to do this in order to be able to see gross sales
> > for the year, as in, how much income was actually received for
> > sales(not expenses), etc.
> >
> > I have near the correct amount with the transaction report showing
> > income:sales and limiting it to 2021, but it:
> >
> > a. Does not capture money from previous years' invoices that is still
> > being paid and
> > b. Assumes invoices that are created in 2021 are fully paid off.
>
> ___
> 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] AqBanking Online Set Up

[Jesse MacDougall]

YAS! General Journal Register ftw! woot!  Even imported five bank
accounts.  Okay so now I manually click the amounts to correct account.
Sweet! Wish I was using GNU Cash Years ago.

On Tue, Jan 4, 2022 at 1:28 PM John Ralls  wrote:

> Yup, 10 months:
>  2021030112[-8]
>  2021123112[-8]
>
> Are you sure that GnuCash imported only December's transactions? Did you
> change the filter on the General Journal register or look in the account's
> register?
>
> Regards,
> John Ralls
>
> > On Jan 4, 2022, at 12:54 PM, Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> >
> > Okay found out Royal Bank only saves transactions upto 120 days for
> OFX.  Nnesense. 365 days is what an Auditor wants.  The file I downloaded
> only had one month once I imported the OFX.  This conflicts with what Royal
> Bank has said so far.  So I called Royal Bank back and everything is fine
> on their end.
> >
> > I then looked at the OFX file in text editor and saw it has
> March-December so the problem is with the format of the OFX file relative
> to GnuCash.  Headers...
> >
> > I've attached the transactions for the Use Case in the email.
> >
> > Any ideas on next steps?
> >
> >
> >
> > On Tue, Jan 4, 2022 at 10:51 AM Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> > The import went smooth.  Alot eaier then a .csv and other softwares I've
> used in my career.  QFX is what I got but Royal Bank only included December
> transactions in the file when I chose the entire year.
> >
> > So this is great.  Can download one file a month and post each
> transaction to proper account usually expense.
> >
> > So now I have to get other information so that gnucash will automate the
> downloading and importing process?  Is this possible? I dunno, I think
> so...Sometimes I think technology is supposed to do something but it
> doesn't 😂🍁🐯🎩🐧
> >
> > On Tue, Jan 4, 2022 at 10:13 AM john  wrote:
> >
> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx
> >
> > At the end of the QFX import you were presented with a window listing
> all of the imported new transactions. Since this is a first import they
> should all have had a yellow background. You can either double-click each
> one or select one or more and right click then select "assign account" from
> the context menu. That will bring up a window with your account tree from
> which you can select the "other" account for the selected transactions.
> When you do this GnuCash records information from the transaction's
> description and will use it to suggest an account for future transactions
> with similar descriptions; those will have a green background as will
> transactions after you've assigned an account to them.
> >
> > If you skipped that step you'll find al of your transactions assigned to
> Imbalance-CAD and you'll need to re-assign them in the register. That
> doesn't train the import matcher.
> >
> > The General Ledger by default filters to the last 30 days. You can
> change that with View>Filter By.
> >
> > Regards,
> > John Ralls
> >
> >
> >> On Jan 3, 2022, at 11:38 PM, Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> >>
> >> I was able to download in QFX format.  I did the import.  How do I
> assign the transactions to the accounts now? I see some of the transactions
> are posted in GL but I do not see the entire year of transactions.  Just
> December.
> >>
> >> On Mon, Jan 3, 2022 at 9:28 PM john  wrote:
> >> Not necessarily. You just need to see if Quicken knows how to connect
> to RBC and if so whether they authenticate with DirectConnect (which
> AQBanking can handle), Express WebConect, or WebConnect (both of which it
> can't).
> >>
> >> It just as possible that what that page is really talking about is
> downloading files; you can figure that out by logging in to your RBC web
> account and looking for a download link. GnuCash can handle OFX, QFX, and
> QIF but not QBO. It's also able to handle CSV though that may take a bit of
> tweaking and in some cases some preprocessing of the CSV.
> >>
> >> Regards,
> >> John Ralls
> >>
> >>
> >>
> >>
> >>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> >>>
> >>> Merci, that eliminates two of the options.  I see a forum to a missing
> institution and connections
> http://www.ofxhome.com/ofxf

Re: [GNC] Trial Balance Report Settings

[Jesse MacDougall]

Yes i saw a setting for this somewhere dont recall exactly

On Tue., Jan. 4, 2022, 16:41 Benjamin Soffer, 
wrote:

> Hello,
>
> Is it possible to configure the trial balance report so that hidden
> accounts or zero-balance accounts would be excluded from the report?
>
> Ben Soffer
> ___
> 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] A good tutorial on connecting online to my bank accounts?

[Jesse MacDougall]

You connect to your bank account and download those transactions into your
Chart Of Accounts.

"move those funds" - Are you talking about cash? or creating Adjusting
Journal Entries?

I haven't found any videos but I am on this process as well.

Check for bank on here https://www.ofxhome.com/index.php/auth/ def want to
get involved here.  Know your bank or whatever

On Tue, Jan 4, 2022 at 12:28 PM John Smith 
wrote:

> Is there a way to use GnuCash to connect to my credit union’s bank account
> and then move those funds from one account to another? Is there a good
> YouTube that explains this or a tutorial of some sort?
>
> Sent from my iPhone
> ___
> 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.
>


-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] AqBanking Online Set Up

[Jesse MacDougall]

The import went smooth.  Alot eaier then a .csv and other softwares I've
used in my career.  QFX is what I got but Royal Bank only included December
transactions in the file when I chose the entire year.

So this is great.  Can download one file a month and post each transaction
to proper account usually expense.

So now I have to get other information so that gnucash will automate the
downloading and importing process?  Is this possible? I dunno, I think
so...Sometimes I think technology is supposed to do something but it
doesn't 😂🍁🐯🎩🐧

On Tue, Jan 4, 2022 at 10:13 AM john  wrote:

>
> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx
>
> At the end of the QFX import you were presented with a window listing all
> of the imported new transactions. Since this is a first import they should
> all have had a yellow background. You can either double-click each one or
> select one or more and right click then select "assign account" from the
> context menu. That will bring up a window with your account tree from which
> you can select the "other" account for the selected transactions. When you
> do this GnuCash records information from the transaction's description and
> will use it to suggest an account for future transactions with similar
> descriptions; those will have a green background as will transactions after
> you've assigned an account to them.
>
> If you skipped that step you'll find al of your transactions assigned to
> Imbalance-CAD and you'll need to re-assign them in the register. That
> doesn't train the import matcher.
>
> The General Ledger by default filters to the last 30 days. You can change
> that with View>Filter By.
>
> Regards,
> John Ralls
>
>
> On Jan 3, 2022, at 11:38 PM, Jesse MacDougall 
> wrote:
>
> I was able to download in QFX format.  I did the import.  How do I assign
> the transactions to the accounts now? I see some of the transactions are
> posted in GL but I do not see the entire year of transactions.  Just
> December.
>
> On Mon, Jan 3, 2022 at 9:28 PM john  wrote:
>
>> Not necessarily. You just need to see if Quicken knows how to connect to
>> RBC and if so whether they authenticate with DirectConnect (which AQBanking
>> can handle), Express WebConect, or WebConnect (both of which it can't).
>>
>> It just as possible that what that page is really talking about is
>> downloading files; you can figure that out by logging in to your RBC web
>> account and looking for a download link. GnuCash can handle OFX, QFX, and
>> QIF but not QBO. It's also able to handle CSV though that may take a bit of
>> tweaking and in some cases some preprocessing of the CSV.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>>
>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall 
>> wrote:
>>
>> Merci, that eliminates two of the options.  I see a forum to a missing
>> institution and connections
>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
>> years ask about Canadian Banks.  No response
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
>>
>> Here someone says TD Bank Canada is not listed but USA is =(
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>>
>> A Quicken friend who uses Royal Bank as well?
>>
>>
>>
>> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
>>
>>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The
>>> Royal Bank of *Canada* is absolutely not a German bank and isn't likely to
>>> support HBCI.
>>> EBICS is also German only.
>>>
>>>
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>>> <
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
>>> suggests that RBC might support OFX Direct Connect based on the list of
>>> software they claim to support, but they're not listed in
>>> https://www.ofxhome.com/ <https://www.ofxhome.com/> so you'd have to
>>> find the connection parameters some other way. The simplest would be to
>>> find a friend who has Quicken and see if it knows how to connect.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
>>> >
>>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
>>> idea
>>> >> where to get this information 

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

You are right. I agree with you.  I noticed this last night.

On Tue, Jan 4, 2022 at 10:02 AM john  wrote:

> No, those are file download types, not connection options. Money means
> OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably
> means QBO but might also mean QFX or QIF. I don't know what Makisoft is nor
> what file type Sage likes. GnuCash can handle the Money or Quicken
> selections. Since Money is certainly OFX pick that and use
> File>Import>import OFX/QFX to import the data. It's both more reliable and
> less effort than importing CSV.
>
> Regards,
> John Ralls
>
>
> On Jan 3, 2022, at 11:12 PM, Jesse MacDougall 
> wrote:
>
> I can see Royal Bank connects with quicken because when I go to download
> my transactions from Royal Bank there is a Quicken option.So now I have
> determined Quicken integrates with Royal Bank I need to obtain the
> connection parameters.  Are these the parameters?
>
> I downloaded the annual transactions in .csv.  Now to import
> *challenge*
> 🍁🐯
>
>
>
>
>
> On Mon, Jan 3, 2022 at 9:28 PM john  wrote:
>
>> Not necessarily. You just need to see if Quicken knows how to connect to
>> RBC and if so whether they authenticate with DirectConnect (which AQBanking
>> can handle), Express WebConect, or WebConnect (both of which it can't).
>>
>> It just as possible that what that page is really talking about is
>> downloading files; you can figure that out by logging in to your RBC web
>> account and looking for a download link. GnuCash can handle OFX, QFX, and
>> QIF but not QBO. It's also able to handle CSV though that may take a bit of
>> tweaking and in some cases some preprocessing of the CSV.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>>
>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall 
>> wrote:
>>
>> Merci, that eliminates two of the options.  I see a forum to a missing
>> institution and connections
>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
>> years ask about Canadian Banks.  No response
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
>>
>> Here someone says TD Bank Canada is not listed but USA is =(
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>>
>> A Quicken friend who uses Royal Bank as well?
>>
>>
>>
>> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
>>
>>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The
>>> Royal Bank of *Canada* is absolutely not a German bank and isn't likely to
>>> support HBCI.
>>> EBICS is also German only.
>>>
>>>
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>>> <
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
>>> suggests that RBC might support OFX Direct Connect based on the list of
>>> software they claim to support, but they're not listed in
>>> https://www.ofxhome.com/ <https://www.ofxhome.com/> so you'd have to
>>> find the connection parameters some other way. The simplest would be to
>>> find a friend who has Quicken and see if it knows how to connect.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
>>> >
>>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
>>> idea
>>> >> where to get this information from.  When I call the bank they talk
>>> to me
>>> >> like I am a terrorist due to Iddiocracy.
>>> >>
>>> >> Never seen this side of technology before.  I read the AqBanking wiki
>>> but
>>> >> didn't advance.
>>> >>
>>> > Try selecting a range of transactions by date, and then downloading
>>> it. See what formats are available for download. The format of each line
>>> should tell you - or someone on this list with more knowledge than I -
>>> which of those options to use.  Most likely it's HBCI, but that's a wild
>>> guess on my part.
>>> >
>>> > There is likely at least one member of this list with an RBC account,
>>> besides yourself. I have only a credit card with them, and that format is
>>> different.
>>> >
>>> > Good luck with this
>>> >
>>> > Cam
>>> >
&

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

I was able to download in QFX format.  I did the import.  How do I assign
the transactions to the accounts now? I see some of the transactions are
posted in GL but I do not see the entire year of transactions.  Just
December.

On Mon, Jan 3, 2022 at 9:28 PM john  wrote:

> Not necessarily. You just need to see if Quicken knows how to connect to
> RBC and if so whether they authenticate with DirectConnect (which AQBanking
> can handle), Express WebConect, or WebConnect (both of which it can't).
>
> It just as possible that what that page is really talking about is
> downloading files; you can figure that out by logging in to your RBC web
> account and looking for a download link. GnuCash can handle OFX, QFX, and
> QIF but not QBO. It's also able to handle CSV though that may take a bit of
> tweaking and in some cases some preprocessing of the CSV.
>
> Regards,
> John Ralls
>
>
>
>
> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall 
> wrote:
>
> Merci, that eliminates two of the options.  I see a forum to a missing
> institution and connections
> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
> years ask about Canadian Banks.  No response
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
>
> Here someone says TD Bank Canada is not listed but USA is =(
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>
> A Quicken friend who uses Royal Bank as well?
>
>
>
> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
>
>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal
>> Bank of *Canada* is absolutely not a German bank and isn't likely to
>> support HBCI.
>> EBICS is also German only.
>>
>>
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>> <
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
>> suggests that RBC might support OFX Direct Connect based on the list of
>> software they claim to support, but they're not listed in
>> https://www.ofxhome.com/ <https://www.ofxhome.com/> so you'd have to
>> find the connection parameters some other way. The simplest would be to
>> find a friend who has Quicken and see if it knows how to connect.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
>> >
>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
>> idea
>> >> where to get this information from.  When I call the bank they talk to
>> me
>> >> like I am a terrorist due to Iddiocracy.
>> >>
>> >> Never seen this side of technology before.  I read the AqBanking wiki
>> but
>> >> didn't advance.
>> >>
>> > Try selecting a range of transactions by date, and then downloading it.
>> See what formats are available for download. The format of each line should
>> tell you - or someone on this list with more knowledge than I - which of
>> those options to use.  Most likely it's HBCI, but that's a wild guess on my
>> part.
>> >
>> > There is likely at least one member of this list with an RBC account,
>> besides yourself. I have only a credit card with them, and that format is
>> different.
>> >
>> > Good luck with this
>> >
>> > Cam
>> >
>> >
>> >
>> > ___
>> > 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.
>>
>
>
> --
> * Please consider adding jesse@macdougall.ninja to your address book.
> This will be my new address.  This gmail address is being retired.
>
>
>
>
>
>
>
>
>
>

-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] AqBanking Online Set Up

[Jesse MacDougall]

Merci, that eliminates two of the options.  I see a forum to a missing
institution and connections
http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
years ask about Canadian Banks.  No response
http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825

Here someone says TD Bank Canada is not listed but USA is =(
http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482

A Quicken friend who uses Royal Bank as well?



On Mon, Jan 3, 2022 at 8:26 PM john  wrote:

> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal
> Bank of *Canada* is absolutely not a German bank and isn't likely to
> support HBCI.
> EBICS is also German only.
>
>
> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
> <
> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
> suggests that RBC might support OFX Direct Connect based on the list of
> software they claim to support, but they're not listed in
> https://www.ofxhome.com/ <https://www.ofxhome.com/> so you'd have to find
> the connection parameters some other way. The simplest would be to find a
> friend who has Quicken and see if it knows how to connect.
>
> Regards,
> John Ralls
>
>
> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
> >
> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
> idea
> >> where to get this information from.  When I call the bank they talk to
> me
> >> like I am a terrorist due to Iddiocracy.
> >>
> >> Never seen this side of technology before.  I read the AqBanking wiki
> but
> >> didn't advance.
> >>
> > Try selecting a range of transactions by date, and then downloading it.
> See what formats are available for download. The format of each line should
> tell you - or someone on this list with more knowledge than I - which of
> those options to use.  Most likely it's HBCI, but that's a wild guess on my
> part.
> >
> > There is likely at least one member of this list with an RBC account,
> besides yourself. I have only a credit card with them, and that format is
> different.
> >
> > Good luck with this
> >
> > Cam
> >
> >
> >
> > ___
> > 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.
>


-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] AqBanking Online Set Up

[Jesse MacDougall]

Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
where to get this information from.  When I call the bank they talk to me
like I am a terrorist due to Iddiocracy.

Never seen this side of technology before.  I read the AqBanking wiki but
didn't advance.

-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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] Closing Books - Pros & Cons

[Jesse MacDougall]

Hi Ryan I am pro accountant.

Closing books means no one can post for that period anymore. So u close
books once your have completed your final review and maybe got some entries
from an accounting firm like me. You probs dont need an accounting firm
though so once all your transactions are in and your cash account agrees to
your bank account you now make your year end entries. Then close.


You dont create a new set of chart of accounts. They roll forward each
year. I think of chart of accounts as the framework of a skyscraper
building being built. Chart of accounts are your financial infastructure.

On Mon., Jan. 3, 2022, 10:31 Ryan Carver,  wrote:

> Hi All,
>
>
>
> I am using Gnucash for my small business (a design consultancy) and I have
> no experience or knowledge of accounting.
>
>
>
> Could someone please explain the PROs & CONs of using the “Close Books”
> feature in layman’s terms?
>
>
>
> The online database states that using the “Close Books” tool will result in
> some report inaccuracies.  Could someone elaborate on which reports would
> result in inaccurate reports?  I ran a few test reports after using the
> “Close Book” tool and I did not notice any report inaccuracies.
>
>
>
> Given my limited accounting knowledge it only seems intuitive that one
> would always want to reset their chart of accounts for each fiscal year so
> you can quickly see the correct period totals for each account.
>
>
>
> What does everyone else do when starting a new fiscal year?
>
>
>
>
>
> Thanks,
>
> Ryan Carver
> ___
> 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] 4.9 account set up of going business

[Jesse MacDougall]

You are right, Rogier.  Entering the Trial Balance from prior years is a
good approach. K.I.S.S.

On Fri, Dec 31, 2021 at 4:59 AM Rogier F. van Vlissingen 
wrote:

> Hi:
> yes, thanks for all your help.
>
> Yesterday, I figured it out in another thread, and I am sitting here
> feeling stupid, for it turns out the answer was the same as it was in 3.8,
> when I originally set it up there. Namely, do not use the opening balance
> feature in the account setup, but rather, simply create the CofA without
> entering any opening balances and then create a single opening transaction
> in the Journal, to set up all the opening balances, in one multiple split
> transaction. Doing it that way, you can immediately check also with
> Imbalance-USD - if you make any entry mistakes the difference will show, so
> you have an instant check.
>
> That is the solution, so now I have happily moved to V4.9, using the
> flatpak route, since Linux Mint is still stuck at V3.8.
>
> The other mistake I arguably had made was that I entered the whole year in
> one session without exiting after every monthly reconciliation, and as a
> result I had no backups, so that, when those two mystery transactions
> somehow dropped out, I was not in a position to revert to end Nov and just
> do over December. However, it was because another user reported having had
> a similar issue that I made up my mind to move to 4.9 to remove any doubt.
> The active users all seem to be on 4.9 as I see on this list.
>
> I was all childishly simple... once you figure it out.
>
>
> In short, I will now finish both 2020 and 2021 in V4.9 before the year is
> out.
>
> On Fri, Dec 31, 2021 at 5:09 AM  wrote:
>
> > Rogier,
> >
> > Both John Ralls and I have posted comments where we have made it clear
> > that you cannot make opening balance entries to the Equity:Retained
> > earnings account from the inital setup dialogue for the CoA. That will
> only
> > allow entries from Asset and Liability accounts to Equity :Openeing
> > Balances. That is by design AFAIK.  I am not sure why that is the case
> but
> > likely the difficulty with programming all possible cases for equity
> > accounts. If your Retained Earnings represents an over all loss then it
> > will have a debit (negative) balance, so the debit and credit entries
> will
> > be reversed from what was described previously
> >
> > If you want to setup the balances for the Equity subaccounts you have to
> > manually enter them from either the Equity:Opening Balances account
> > register or the account register for the specific Equity sub-account you
> > are setting the balance and not from the setup dialogue for the chart of
> > accounts.
> >
> > David Cousens
> >
> > On Thu, 2021-12-30 at 16:01 -0500, Rogier F. van Vlissingen wrote:
> >
> >
> >
> > I am sitting here trying that, but in the setup, when you edit the
> > accounts, it only allows posting of the entire account to "opening
> > balances." I can't see a way to split it and put the appropriate amount
> in
> > Retained Earnings. In the 3.8 version I was able to somehow correct the
> > balances, I believe with a transfer, but I cannot remember for ssure.
> >
> > On Thu, Dec 30, 2021 at 3:52 PM Rogier F. van Vlissingen <
> > vlisc...@gmail.com> wrote:
> >
> > It happens to be a loss.
> >
> > I seem to be missing something. For all the other accounts, I simply post
> > to the account with the balancing transaction going to Opening Balances.
> > But because of what I described, I get Opening Balances $x and Retained
> > Earnings $0. Nothing I can think of gets the money from Opening Balances
> > into Retained Earnings.
> >
> > Or is it that when I set it up, I have to do some split transactions to
> > make sure the appropriate amount ends up in Retained Earnings and the
> > remainder is Retained Earnings?
> >
> > Not sure how, but I could give that a try, I will just have to set that
> up
> > all over again.
> >
> >
> >
> >
> >
> >
> >
> > On Thu, Dec 30, 2021 at 3:33 PM  wrote:
> >
> > Rogier
> >
> > What is the form of the transaction being used to record the opening
> > balance of the Retained Earnings account. Assuming your business has been
> > profitable and it is not a loss, then the transaction to record its
> opening
> > balances it  should be something like
> > Dr
> >  Cr
> > Equity:Opening Balances   xxx
> > Equity: Retained Earnings xxx
> >
> > This should reduce the balance of the Retained earnings account while
> > keeping the overall Equity account balance constant.
> >
> > David Cousens
> >
> > On Thu, 2021-12-30 at 15:18 -0500, Rogier F. van Vlissingen wrote:
> >
> >
> >
> > Thanks, I do not get it. I can set up all the opening balances, except
> one
> > retained earnings. To me retained earnings on 1/1/2020 is the accumulated
> > position from prior years, I do not see how I can finagle that via what
> sub
> > accounts. Evidently, when I set up the 

Re: [GNC] Reports, how to use

[Jesse MacDougall]

Cant u import the accounts and transactions?

On Mon., Dec. 27, 2021, 18:22 Chuck,  wrote:

> Have copy Gnucash/saved-reports-2.4-backup &
> Gnucash/saved-reports-2.4 from before, had to replace computer due to age &
> not being able to access spreadsheets after upgrade, had to downgrade for
> that to work.
> How can I now use the backup files?
> OK I am an end user using pop-OS Linux 20.04?
> Chuck598
>
> --
> *Sunday**, December 26, 2021*
> *Luke 2:13-14*
> *And suddenly there was with the angel a multitude of the heavenly host
> praising God, and saying,  Glory to God in the highest, and on earth peace,
> good will toward men. *
> *For God hath not given us the spirit of fear; but of power, and of love,
> and of a sound mind.*
> *2 Timothy 1:7*
> *Let the Spirit renew your thoughts and attitudes.*
> *Ephesians 4:23 *
> *“See if I will not throw open the floodgates of heaven and pour out so
> much blessing that you will not have room enough for it.” *
> *Malachi 3:10*
>
> *Heavenly Father, You promised to pour out blessings on those who tithe in
> Your name. Help us to take You at Your word and to trust in Your provision
> as we give back to You and share our abundance with others. *
> *Amen.*
> *"Be Kind to our email friends"*
>
> Forwarding this?  PLEASE REMOVE all email addresses before you send it on
> using the BCC area When forwarding to several people at once.
> ___
> 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] Account Name Fonts

[Jesse MacDougall]

Great question

On Wed., Dec. 22, 2021, 08:24 Gyle McCollam,  wrote:

> Is there a way to have an account name with different font attributes for
> part of the name?  I want to have a larger font and bold for part of an
> account name.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
> ___
> 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] Another Beginner Accounting Question

[Jesse MacDougall]

Just add the total amount of AR that is owed to you from the customer.
KISS (keep it simple sally)

On Wed., Dec. 22, 2021, 03:21 Patrick Skelton, 
wrote:

> Hi,
>
> Just when I was thinking I had accumulated all the pieces of the jigsaw I
> need, I discovered the A/R account.
>
> I have a shop that charges 50% margin on whatever they sell. So, if they
> sell one candle for £12 then I will invoice them only for £6. They get 30
> days credit, so ideally I'd use the A/R system. I've played around with
> this and it seems to do what I expect to the Balance Sheet and Profit &
> Loss Report except for one thing: I seem to lose any record of the 50% of
> the total sales value that they have taken.
>
> There is a Discount column in the invoice but this doesn't seem to show up
> anywhere in the accounts. I'd like to have some record of the money I am
> 'losing' in sales commission, maybe as an expense.
>
> Can anyone offer any advice on how this might best be approached, please?
>
> Kind wishes - Patrick
> ___
> 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.

[GNC] (no subject)

[Jesse MacDougall]

I am trying to add a "label"(not sure if that is the right word) on Income
Statement "Cost of Goods Sold" and put accounts under COGS.  Like there is
with "Total Revenue".  What is happening is COGS is a parent account with
sub accounts but I want to make COGS a label.
  I am trying to achieve a bolded "COGS" on the IS.  I don't see anywhere
to achieve this.  Been stuck on this a few hours.  I have COGS as a
placeholder currently.  Here is what I see:



-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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.