[GNC] Demo accounts
> What I'm looking for is a set of demo accounts. Have another look at the GnuCash Tutorial and Concepts Guide. You could do something to work with that data and extend it to using csv. Example data ( https://lists.gnucash.org/pipermail/gnucash-user/attachments/20210718/2f60caee/attachment.obj ) based on GnuCash Tutorial and Concepts Guide Part II. Managing Personal Finances. The csv import works better if you import the accounts first. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Demo accounts
Thanks very much all. I managed to use the CSV import, as suggested, to import CSV files with spurious values, but good enough to make it look like a basic set of accounts for an individual... at least good enough to show the reports I wanted. Michelle. On Sun, 2023-02-05 at 14:20 -0500, R. Victor Klassen wrote: > I would start by exporting some of your own stuff to .csv > > That will tell you what the native GNUCash csv input format looks > like. > > Now you can go to a spreadsheet and create transactions to your > heart’s content using dates that are based on formulae (like every 14 > days put in the same transaction). and so on. > Save that to csv, and import it into a brand new file. > > > On Feb 5, 2023, at 6:05 AM, Michelle wrote: > > > > This is going to be a bit of an odd question, but hey ho. > > > > I have a very small channel and would like to make a small video > > about > > GnuCash and reporting insights for the average home user. > > > > What I'm looking for is a set of demo accounts. > > > > Nothing serious, just a bank account and a credit card, showing > > wages > > coming into the bank account monthly, the credit card being paid > > off > > monthly, and a series of transactions on the credit card, like > > supermarket, cd, dvd, fuel, that sort of thing... covering maybe > > five > > years with some simple categories to cover the spending. > > > > So, nothing complicated like interest or multiple currencies, or > > anything like that. > > > > Is there something out there please, or something I can do to make > > creation a bit easier? > > > > Many thanks, > > > > Michelle. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Demo accounts
I would start by exporting some of your own stuff to .csv That will tell you what the native GNUCash csv input format looks like. Now you can go to a spreadsheet and create transactions to your heart’s content using dates that are based on formulae (like every 14 days put in the same transaction). and so on. Save that to csv, and import it into a brand new file. > On Feb 5, 2023, at 6:05 AM, Michelle wrote: > > This is going to be a bit of an odd question, but hey ho. > > I have a very small channel and would like to make a small video about > GnuCash and reporting insights for the average home user. > > What I'm looking for is a set of demo accounts. > > Nothing serious, just a bank account and a credit card, showing wages > coming into the bank account monthly, the credit card being paid off > monthly, and a series of transactions on the credit card, like > supermarket, cd, dvd, fuel, that sort of thing... covering maybe five > years with some simple categories to cover the spending. > > So, nothing complicated like interest or multiple currencies, or > anything like that. > > Is there something out there please, or something I can do to make > creation a bit easier? > > Many thanks, > > Michelle. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Demo accounts
Michelle Create a new gnu file and follow the assistant steps and choose common accounts , this should give you the basics Regard Murugan > On 05-02-2023, at 08:16, Michelle wrote: > > This is going to be a bit of an odd question, but hey ho. > > I have a very small channel and would like to make a small video about > GnuCash and reporting insights for the average home user. > > What I'm looking for is a set of demo accounts. > > Nothing serious, just a bank account and a credit card, showing wages > coming into the bank account monthly, the credit card being paid off > monthly, and a series of transactions on the credit card, like > supermarket, cd, dvd, fuel, that sort of thing... covering maybe five > years with some simple categories to cover the spending. > > So, nothing complicated like interest or multiple currencies, or > anything like that. > > Is there something out there please, or something I can do to make > creation a bit easier? > > Many thanks, > > Michelle. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Demo accounts
Just a suggestion - Using the Gnucash Tutorial and Concepts Guide one can build step-by-step a sample file beginning with "Putting It All Together" on page 28 (v4). I think this file, though not for a 5 year period, could suffice to give you examples of the types of transactions you're talking about. One could always add more transactions to include a longer span of time. I've referred back to the Tutorial countless times to refresh my memory. On 2/5/2023 5:05 AM, Michelle wrote: This is going to be a bit of an odd question, but hey ho. I have a very small channel and would like to make a small video about GnuCash and reporting insights for the average home user. What I'm looking for is a set of demo accounts. Nothing serious, just a bank account and a credit card, showing wages coming into the bank account monthly, the credit card being paid off monthly, and a series of transactions on the credit card, like supermarket, cd, dvd, fuel, that sort of thing... covering maybe five years with some simple categories to cover the spending. So, nothing complicated like interest or multiple currencies, or anything like that. Is there something out there please, or something I can do to make creation a bit easier? Many thanks, Michelle. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Demo accounts
This is going to be a bit of an odd question, but hey ho. I have a very small channel and would like to make a small video about GnuCash and reporting insights for the average home user. What I'm looking for is a set of demo accounts. Nothing serious, just a bank account and a credit card, showing wages coming into the bank account monthly, the credit card being paid off monthly, and a series of transactions on the credit card, like supermarket, cd, dvd, fuel, that sort of thing... covering maybe five years with some simple categories to cover the spending. So, nothing complicated like interest or multiple currencies, or anything like that. Is there something out there please, or something I can do to make creation a bit easier? Many thanks, Michelle. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.