Re: Copying transactions from an account to the general ledger
On 2/6/2018 12:15 PM, Mike Donovan wrote: Having recorded many transactions to the cash account, I would like to copy these to the GL (which has no transactions currently) and then use the GL for recording all future transactions. Can this be done? Thanks. Sent from Mail for Windows 10 Review the intro to double entry bookkeeping. a) The cash account IS a ledger account. b) Each transaction you entered (entering from the cash account) had ANOTHER (at least one other) account associated with it, the other side of the transactions. If you did not specify that other account, gnucash used the account "Imbalance" as a (temporary) default account. You need to FIX each of these (change to the correct account) c) Gnucash only has a ledger. The journal is virtual (you can run a report that will show it to you). Michael D Novack ___ 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: Copying transactions from an account to the general ledger
Adrien: Thanks again. Geert’s recommendation regarding the filter solved my problem. Regards, Mike Sent from Mail for Windows 10 From: Adrien Monteleone Sent: Tuesday, February 6, 2018 3:43 PM To: gnucash-user Subject: Re: Copying transactions from an account to the general ledger Mike, See the replies by Geert and John. The GL by default only shows the last 30 days of transactions. If the transactions you entered previously were dated more than 30 days ago, you won’t see them. Turn off the default filter first as they mentioned. As John noted, be wary of entering directly in the GL. You CAN do so, but it’s not necessarily the best practice. Unlike other registers, it is not an account, merely a view of all accounts. Entering from another register, you can default to a split containing the account you are in holding the balance. The GL has no such option since it isn’t an account, you’ll have to be careful to enter both debit and credit lines before entering out of the transaction or you’ll have a mess of unbalanced entries to clean up. For example, if I’m entering an expense paid with cash, I open the cash account register, enter my debit expense split and the register includes the matching split as a credit to cash already there for me. I also don’t have the option of deleting that cash split since it would ‘un-link’ the transaction to that register. This helps me enter transactions properly without mistakes. Normally, I use Transaction Journal view by default, but this is even more important if using Basic view which only shows one account split. Also, please copy the list on all replies so others can benefit from the exchange. Regards, Adrien > On Feb 6, 2018, at 1:42 PM, Mike Donovan wrote: > > Adrien, > > Thanks for your reply. When I go to Tools> General Ledger, I show a new line > waiting for transaction entry. No other transactions are shown. Is it > possible that I need to change a setting to get your (favorable) result? > > Regards, > Mike > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 > > From: Adrien Monteleone <mailto:adrien.montele...@gmail.com> > Sent: Tuesday, February 6, 2018 12:59 PM > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Subject: Re: Copying transactions from an account to the general ledger > > Mike, > > There’s no copying anything to the General Ledger. The GL is simply a > consolidated view of all accounts. Your transactions should be there. I just > did a test with a fresh book, entered some transactions in Cash, opened the > GL and the transactions were all there. I presume you are going to Tools > > General Ledger right? > > Certainly you can enter transactions in the GL only if you prefer. > Personally, I like to enter them in the account the money is coming from to > keep my entries straight. (some enter their credit card charges as expenses > from the card liability account for the same reason) > > > Regards, > Adrien > > > On Feb 6, 2018, at 11:15 AM, Mike Donovan > > wrote: > > > > Having recorded many transactions to the cash account, I would like to copy > > these to the GL (which has no transactions currently) and then use the GL > > for recording all future transactions. Can this be done? Thanks. > > > > Sent from Mail for Windows 10 > > > > > > > > --- > > This email has been checked for viruses by Avast antivirus software. > > https://www.avast.com/antivirus > > ___ > > 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 <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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. > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_sou
Re: Re: Copying transactions from an account to the general ledger
Geert: Thanks for your helpful reply. I can now see all transactions. Best Wishes, Mike Sent from Mail for Windows 10 --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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: Copying transactions from an account to the general ledger
Mike, See the replies by Geert and John. The GL by default only shows the last 30 days of transactions. If the transactions you entered previously were dated more than 30 days ago, you won’t see them. Turn off the default filter first as they mentioned. As John noted, be wary of entering directly in the GL. You CAN do so, but it’s not necessarily the best practice. Unlike other registers, it is not an account, merely a view of all accounts. Entering from another register, you can default to a split containing the account you are in holding the balance. The GL has no such option since it isn’t an account, you’ll have to be careful to enter both debit and credit lines before entering out of the transaction or you’ll have a mess of unbalanced entries to clean up. For example, if I’m entering an expense paid with cash, I open the cash account register, enter my debit expense split and the register includes the matching split as a credit to cash already there for me. I also don’t have the option of deleting that cash split since it would ‘un-link’ the transaction to that register. This helps me enter transactions properly without mistakes. Normally, I use Transaction Journal view by default, but this is even more important if using Basic view which only shows one account split. Also, please copy the list on all replies so others can benefit from the exchange. Regards, Adrien > On Feb 6, 2018, at 1:42 PM, Mike Donovan wrote: > > Adrien, > > Thanks for your reply. When I go to Tools> General Ledger, I show a new line > waiting for transaction entry. No other transactions are shown. Is it > possible that I need to change a setting to get your (favorable) result? > > Regards, > Mike > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 > > From: Adrien Monteleone <mailto:adrien.montele...@gmail.com> > Sent: Tuesday, February 6, 2018 12:59 PM > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Subject: Re: Copying transactions from an account to the general ledger > > Mike, > > There’s no copying anything to the General Ledger. The GL is simply a > consolidated view of all accounts. Your transactions should be there. I just > did a test with a fresh book, entered some transactions in Cash, opened the > GL and the transactions were all there. I presume you are going to Tools > > General Ledger right? > > Certainly you can enter transactions in the GL only if you prefer. > Personally, I like to enter them in the account the money is coming from to > keep my entries straight. (some enter their credit card charges as expenses > from the card liability account for the same reason) > > > Regards, > Adrien > > > On Feb 6, 2018, at 11:15 AM, Mike Donovan > > wrote: > > > > Having recorded many transactions to the cash account, I would like to copy > > these to the GL (which has no transactions currently) and then use the GL > > for recording all future transactions. Can this be done? Thanks. > > > > Sent from Mail for Windows 10 > > > > > > > > --- > > This email has been checked for viruses by Avast antivirus software. > > https://www.avast.com/antivirus > > ___ > > 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 <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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. > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> > Virus-free. www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> ___
Re: Copying transactions from an account to the general ledger
> On Feb 6, 2018, at 9:15 AM, Mike Donovan wrote: > > Having recorded many transactions to the cash account, I would like to copy > these to the GL (which has no transactions currently) and then use the GL for > recording all future transactions. Can this be done? Thanks. GnuCash doesn’t have a GL as a separate account. There’s a General Ledger register view (Tools>General Ledger; afterwards use View>Filter By... to select the date range displayed) that shows all transactions sorted by date and in split view; this is the same view that you get if you run Edit>Find... from the Accounts page. Assuming that the transactions that you recorded in the cash account were in fact cash transactions and that you want to track your cash balance (GnuCash’s “common accounts” template includes a “Cash in Wallet” account for this purpose) then you’re doing the right thing. You don’t want a GL account that isn’t associated with a particular actual account or physical location of currency (e.g. cash in my wallet, cash in wife’s wallet, cash in wall safe, etc.); you’ll just wind up with an unbalanceable mess. Regards, John Ralls ___ 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: Copying transactions from an account to the general ledger
Mike, There’s no copying anything to the General Ledger. The GL is simply a consolidated view of all accounts. Your transactions should be there. I just did a test with a fresh book, entered some transactions in Cash, opened the GL and the transactions were all there. I presume you are going to Tools > General Ledger right? Certainly you can enter transactions in the GL only if you prefer. Personally, I like to enter them in the account the money is coming from to keep my entries straight. (some enter their credit card charges as expenses from the card liability account for the same reason) Regards, Adrien > On Feb 6, 2018, at 11:15 AM, Mike Donovan wrote: > > Having recorded many transactions to the cash account, I would like to copy > these to the GL (which has no transactions currently) and then use the GL for > recording all future transactions. Can this be done? Thanks. > > Sent from Mail for Windows 10 > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > ___ > 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: Copying transactions from an account to the general ledger
Op dinsdag 6 februari 2018 18:15:35 CET schreef Mike Donovan: > Having recorded many transactions to the cash account, I would like to copy > these to the GL (which has no transactions currently) and then use the GL > for recording all future transactions. Can this be done? Thanks. > > Sent from Mail for Windows 10 *All* transactions are in the general ledger automatically. If you don't see them there, that's probably because the general ledger is by default filtered to the transactions of the past 30 days. Try View/Filter By... to remove this filter. Unfortunately it's not retained so you'll have to do it each time you open the GL. Regards, Geert ___ 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: Copying transactions from an account to the general ledger
Hi Mike The easiest way I know of, to move ALL the transactions from one account to an empty account, is to simply rename the account! On 6 February 2018 at 17:15, Mike Donovan wrote: > Having recorded many transactions to the cash account, I would like to copy > these to the GL (which has no transactions currently) and then use the GL for > recording all future transactions. Can this be done? Thanks. -- Anthony Hepple 01704 227828 / 07931 504049 http://www.dhdevelopment.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.
Copying transactions from an account to the general ledger
Having recorded many transactions to the cash account, I would like to copy these to the GL (which has no transactions currently) and then use the GL for recording all future transactions. Can this be done? Thanks. Sent from Mail for Windows 10 --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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.