[GNC] Duplicate Transactions

2022-06-27 Thread 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

[GNC] Eliminate Manual Download of Transaction

2022-03-01 Thread 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

Re: [GNC] PDF creation option

2022-02-04 Thread 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 reports, and set the report to use the > two-column layout. I just discovered this option

Re: [GNC] Vanguard OFX Access

2022-01-28 Thread 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

Re: [GNC] How to properly import a csv with the correct settings.

2022-01-27 Thread 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

Re: [GNC] Accounting Question re Balance Sheet

2022-01-20 Thread 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

Re: [GNC] OneDrive and GnuCash

2022-01-18 Thread 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

Re: [GNC] Period Ends

2022-01-07 Thread Jesse MacDougall
gt; -- > *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 > >

Re: [GNC] Period Ends

2022-01-07 Thread 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

Re: [GNC] Tax question - gross income for the year

2022-01-05 Thread 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 or Income Statement. (same > report, different names) > > If you are working on a cash basis, you'll have to make

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread Jesse MacDougall
000[-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 MacDougal

Re: [GNC] Trial Balance Report Settings

2022-01-04 Thread 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 >

Re: [GNC] A good tutorial on connecting online to my bank accounts?

2022-01-04 Thread 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

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread Jesse MacDougall
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. > >

Re: [GNC] AqBanking Online Set Up

2022-01-04 Thread Jesse MacDougall
ng 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

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread Jesse MacDougall
. > > 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

Re: [GNC] AqBanking Online Set Up

2022-01-03 Thread Jesse MacDougall
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

[GNC] AqBanking Online Set Up

2022-01-03 Thread 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

Re: [GNC] Closing Books - Pros & Cons

2022-01-03 Thread 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

Re: [GNC] 4.9 account set up of going business

2021-12-31 Thread 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

Re: [GNC] Reports, how to use

2021-12-28 Thread 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 >

Re: [GNC] Account Name Fonts

2021-12-22 Thread 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 > >

Re: [GNC] Another Beginner Accounting Question

2021-12-22 Thread 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

[GNC] (no subject)

2021-12-18 Thread 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