Simple (web?) application for producing something like a bank statement - ideas?

[Chris Green]

I want a simple way to maintain something like a bank account.  I.e. I
want to enter debits and credits and be able to show the running balance
in the account, something like:-

Date            Credit  Debit   Balance         Description
2012-01-01      0.00            0.00            Start of 2012, Initial balance
2012-01-01              200     -200.00         Livery for January (4 weeks)
2012-01-05              21.69   -221.69         1 x HiFi Lite, 1 x Pasture Mix
2012-01-06      200.00          -21.69          Cheque
2012-01-19              10.99   -32.68          1 x HiFi Lite
2012-01-28              87.5    -120.18         Hay from Owen Smith, 5 bales for £175
2012-02-01              200     -320.18         Livery for February (to 26th)
2012-02-02      200.00          -120.18         Cash
2012-02-04      100.18          -20.00          Cheque
2012-02-09              43.38   -63.38          2 x HiFi Lite, 2 x Pasture Mix (invoice 99)
2012-03-01              200     -263.38         Livery for March (to 25th)
2012-03-02      200.00          -63.38          Cash


Ideally one would only need to enter credit/debit and description, the
date would default to today (with the ability to change it) and the
running balance would be automatically calculated.

I already have a PHP/Database application for doing this which I wrote
myself (using DokuWiki as a framework, simplifies the HTML side of
things) but I'm really after something with much simpler data entry as
my solution enters the data by editing the wiki.

A spreadsheet does some of what I want but I've never seen a neat
solution to showing a running balance, it always requires entering a
formula in the Balance column for every new entry.

Any ideas anyone?

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Mark Widdicombe-2]

On 13 June 2012 10:49, Chris Green <[hidden email]> wrote:

> I want a simple way to maintain something like a bank account.  I.e. I
> want to enter debits and credits and be able to show the running balance
> in the account, something like:-
>
> Date            Credit  Debit   Balance         Description
> 2012-01-01      0.00            0.00            Start of 2012, Initial balance
> 2012-01-01              200     -200.00         Livery for January (4 weeks)
> 2012-01-05              21.69   -221.69         1 x HiFi Lite, 1 x Pasture Mix
> 2012-01-06      200.00          -21.69          Cheque
> 2012-01-19              10.99   -32.68          1 x HiFi Lite
> 2012-01-28              87.5    -120.18         Hay from Owen Smith, 5 bales for £175
> 2012-02-01              200     -320.18         Livery for February (to 26th)
> 2012-02-02      200.00          -120.18         Cash
> 2012-02-04      100.18          -20.00          Cheque
> 2012-02-09              43.38   -63.38          2 x HiFi Lite, 2 x Pasture Mix (invoice 99)
> 2012-03-01              200     -263.38         Livery for March (to 25th)
> 2012-03-02      200.00          -63.38          Cash
>
>
> Ideally one would only need to enter credit/debit and description, the
> date would default to today (with the ability to change it) and the
> running balance would be automatically calculated.
>
> I already have a PHP/Database application for doing this which I wrote
> myself (using DokuWiki as a framework, simplifies the HTML side of
> things) but I'm really after something with much simpler data entry as
> my solution enters the data by editing the wiki.
>
> A spreadsheet does some of what I want but I've never seen a neat
> solution to showing a running balance, it always requires entering a
> formula in the Balance column for every new entry.
>
> Any ideas anyone?
>
> --
> Chris Green

a spreadsheet is probably the best solution.  If you enter the formula
in the top cell of the running balance column yoiu can use the drag
handle to automatically enter the appropriate formula in all the cells
below it; you don't need to enter the formula in each cell manually.

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[chris-776]

On Wed, 2012-06-13 at 09:49 +0100, Chris Green wrote:

> I want a simple way to maintain something like a bank account.  I.e. I
> want to enter debits and credits and be able to show the running balance
> in the account, something like:-
>
> Date            Credit  Debit   Balance         Description
> 2012-01-01      0.00            0.00            Start of 2012, Initial balance
> 2012-01-01              200     -200.00         Livery for January (4 weeks)
> 2012-01-05              21.69   -221.69         1 x HiFi Lite, 1 x Pasture Mix
> 2012-01-06      200.00          -21.69          Cheque
> 2012-01-19              10.99   -32.68          1 x HiFi Lite
> 2012-01-28              87.5    -120.18         Hay from Owen Smith, 5 bales for £175
> 2012-02-01              200     -320.18         Livery for February (to 26th)
> 2012-02-02      200.00          -120.18         Cash
> 2012-02-04      100.18          -20.00          Cheque
> 2012-02-09              43.38   -63.38          2 x HiFi Lite, 2 x Pasture Mix (invoice 99)
> 2012-03-01              200     -263.38         Livery for March (to 25th)
> 2012-03-02      200.00          -63.38          Cash
>
>
> Ideally one would only need to enter credit/debit and description, the
> date would default to today (with the ability to change it) and the
> running balance would be automatically calculated.
>
> I already have a PHP/Database application for doing this which I wrote
> myself (using DokuWiki as a framework, simplifies the HTML side of
> things) but I'm really after something with much simpler data entry as
> my solution enters the data by editing the wiki.
>
> A spreadsheet does some of what I want but I've never seen a neat
> solution to showing a running balance, it always requires entering a
> formula in the Balance column for every new entry.
>
> Any ideas anyone?
>
> --
> Chris Green
>

gnucash
in the repositories
 been using it for years

--
Cheers the Kiwi


--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Chris Green]

>
> a spreadsheet is probably the best solution.  If you enter the formula
> in the top cell of the running balance column yoiu can use the drag
> handle to automatically enter the appropriate formula in all the cells
> below it; you don't need to enter the formula in each cell manually.
>
But the cells aren't there below it until the 'next line' has been entered.

I don't want a huge table of emptiness with just a few rows and columns
with data in them (as seems to be the norm with most Spreadsheet use I
have seen).  

When there are (say) eight debit/credit entries in my table I just want
to see eight rows in the spreadsheet with (probably) just three or four
columns.

If I understand you correctly you are saying one should copy the formula
for the running balance into the Balance column for lots of columns into
the future - is this right?

Another issue is that the formula is *different* for the running balance
as you go down isn't it as it's the sum of all rows up to and including
the current row and the current row changes as you go down the table.  I
seem to remember there isn't an easy way to code this in most
spreadsheets.

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Jim Byrnes-4]

On 06/13/2012 04:38 AM, Chris Green wrote:

>>
>> a spreadsheet is probably the best solution.  If you enter the formula
>> in the top cell of the running balance column yoiu can use the drag
>> handle to automatically enter the appropriate formula in all the cells
>> below it; you don't need to enter the formula in each cell manually.
>>
> But the cells aren't there below it until the 'next line' has been entered.
>
> I don't want a huge table of emptiness with just a few rows and columns
> with data in them (as seems to be the norm with most Spreadsheet use I
> have seen).
>
> When there are (say) eight debit/credit entries in my table I just want
> to see eight rows in the spreadsheet with (probably) just three or four
> columns.

In that case turn off the display of grid lines so unused cells are not
shown.  Then if you know how many entries you will have to make just
copy your formula to that many lines.

> If I understand you correctly you are saying one should copy the formula
> for the running balance into the Balance column for lots of columns into
> the future - is this right?
>
> Another issue is that the formula is *different* for the running balance
> as you go down isn't it as it's the sum of all rows up to and including
> the current row and the current row changes as you go down the table.  I
> seem to remember there isn't an easy way to code this in most
> spreadsheets.
>

The spreadsheet will change the formula to the correct one for you.
Just select the last cell in your balance column and copy it to the
clipboard.  Then select the cell immediately under that cell and drag it
down the number of lines necessary to match the number of entries you
will make.  Then set the spreadsheet to move one cell to the right when
hitting the enter key.  When you have entered all the lines date hit
down arrow then home and you will be at the start of a fresh line ready
to enter more data.

Regards,  Jim



--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Jake Maier]

> -----Original Message-----
> From: [hidden email] [mailto:ubuntu-users-
> [hidden email]] On Behalf Of Jim Byrnes
> Sent: Wednesday, June 13, 2012 11:53 AM
> To: [hidden email]
> Subject: Re: Simple (web?) application for producing something like a
> bank statement - ideas?
>
> On 06/13/2012 04:38 AM, Chris Green wrote:
> >>
> >> a spreadsheet is probably the best solution.  If you enter the
> >> formula in the top cell of the running balance column yoiu can use
> >> the drag handle to automatically enter the appropriate formula in
> all
> >> the cells below it; you don't need to enter the formula in each cell
> manually.
> >>
> > But the cells aren't there below it until the 'next line' has been
> entered.
> >
> > I don't want a huge table of emptiness with just a few rows and
> > columns with data in them (as seems to be the norm with most
> > Spreadsheet use I have seen).
> >
> > When there are (say) eight debit/credit entries in my table I just
> > want to see eight rows in the spreadsheet with (probably) just three
> > or four columns.
>
> In that case turn off the display of grid lines so unused cells are not
> shown.  Then if you know how many entries you will have to make just
> copy your formula to that many lines.
>
> > If I understand you correctly you are saying one should copy the
> > formula for the running balance into the Balance column for lots of
> > columns into the future - is this right?
> >
> > Another issue is that the formula is *different* for the running
> > balance as you go down isn't it as it's the sum of all rows up to and
> > including the current row and the current row changes as you go down
> > the table.  I seem to remember there isn't an easy way to code this
> in
> > most spreadsheets.
> >
>
> The spreadsheet will change the formula to the correct one for you.
> Just select the last cell in your balance column and copy it to the
> clipboard.  Then select the cell immediately under that cell and drag
> it down the number of lines necessary to match the number of entries
> you will make.  Then set the spreadsheet to move one cell to the right
> when hitting the enter key.  When you have entered all the lines date
> hit down arrow then home and you will be at the start of a fresh line
> ready to enter more data.
>
> Regards,  Jim
>
>

[JM]
Another option is to use a database program, but those are more
sophisticated to operate.
What about a financial program? GnuCash is great, free and will do what you
want and even will do things you may want to do in the future.
Jake


--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[william drescher]

On 6/13/2012 5:38 AM, Chris Green wrote:

>>
>> a spreadsheet is probably the best solution.  If you enter the formula
>> in the top cell of the running balance column yoiu can use the drag
>> handle to automatically enter the appropriate formula in all the cells
>> below it; you don't need to enter the formula in each cell manually.
>>
> But the cells aren't there below it until the 'next line' has been entered.
>
> I don't want a huge table of emptiness with just a few rows and columns
> with data in them (as seems to be the norm with most Spreadsheet use I
> have seen).
>
> When there are (say) eight debit/credit entries in my table I just want
> to see eight rows in the spreadsheet with (probably) just three or four
> columns.
>
> If I understand you correctly you are saying one should copy the formula
> for the running balance into the Balance column for lots of columns into
> the future - is this right?
>
> Another issue is that the formula is *different* for the running balance
> as you go down isn't it as it's the sum of all rows up to and including
> the current row and the current row changes as you go down the table.  I
> seem to remember there isn't an easy way to code this in most
> spreadsheets.
>

You can set up your spreadsheet with x data rows (each of which
has a running balance) and a total row(basically a placeholder).
Set the running balance cells to add the transaction amount for
that row to the running balance of the prior row.

When you need to add a new data row, insert it just above the
total row and LO and OO will adjust the totals of the total row
and (I think - untested) copy the formulas from the prior row,
thus keeping the running balance correct.

bill



--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Colin Law-4]

On 13 June 2012 10:27, chris <[hidden email]> wrote:

> On Wed, 2012-06-13 at 09:49 +0100, Chris Green wrote:
>> I want a simple way to maintain something like a bank account.  I.e. I
>> want to enter debits and credits and be able to show the running balance
>> in the account, something like:-
>>
>> Date            Credit  Debit   Balance         Description
>> 2012-01-01      0.00            0.00            Start of 2012, Initial balance
>> 2012-01-01              200     -200.00         Livery for January (4 weeks)
>> 2012-01-05              21.69   -221.69         1 x HiFi Lite, 1 x Pasture Mix
>> 2012-01-06      200.00          -21.69          Cheque
>> 2012-01-19              10.99   -32.68          1 x HiFi Lite
>> 2012-01-28              87.5    -120.18         Hay from Owen Smith, 5 bales for £175
>> 2012-02-01              200     -320.18         Livery for February (to 26th)
>> 2012-02-02      200.00          -120.18         Cash
>> 2012-02-04      100.18          -20.00          Cheque
>> 2012-02-09              43.38   -63.38          2 x HiFi Lite, 2 x Pasture Mix (invoice 99)
>> 2012-03-01              200     -263.38         Livery for March (to 25th)
>> 2012-03-02      200.00          -63.38          Cash
>>
>>
>> Ideally one would only need to enter credit/debit and description, the
>> date would default to today (with the ability to change it) and the
>> running balance would be automatically calculated.
>>
>> I already have a PHP/Database application for doing this which I wrote
>> myself (using DokuWiki as a framework, simplifies the HTML side of
>> things) but I'm really after something with much simpler data entry as
>> my solution enters the data by editing the wiki.
>>
>> A spreadsheet does some of what I want but I've never seen a neat
>> solution to showing a running balance, it always requires entering a
>> formula in the Balance column for every new entry.
>>
>> Any ideas anyone?
>>
>> --
>> Chris Green
>>
>
> gnucash
> in the repositories
>  been using it for years

+1, excellent s/w

Colin

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Chris Green]

On Wed, Jun 13, 2012 at 10:52:43AM -0500, Jim Byrnes wrote:

> On 06/13/2012 04:38 AM, Chris Green wrote:
> >>
> >>a spreadsheet is probably the best solution.  If you enter the formula
> >>in the top cell of the running balance column yoiu can use the drag
> >>handle to automatically enter the appropriate formula in all the cells
> >>below it; you don't need to enter the formula in each cell manually.
> >>
> >But the cells aren't there below it until the 'next line' has been entered.
> >
> >I don't want a huge table of emptiness with just a few rows and columns
> >with data in them (as seems to be the norm with most Spreadsheet use I
> >have seen).
> >
> >When there are (say) eight debit/credit entries in my table I just want
> >to see eight rows in the spreadsheet with (probably) just three or four
> >columns.
>
> In that case turn off the display of grid lines so unused cells are
> not shown.  Then if you know how many entries you will have to make
> just copy your formula to that many lines.
>

But I don't know how many entries there will be - do you know how many
lines there will be on your bank statement next April?  :-)

> >If I understand you correctly you are saying one should copy the formula
> >for the running balance into the Balance column for lots of columns into
> >the future - is this right?
> >
> >Another issue is that the formula is *different* for the running balance
> >as you go down isn't it as it's the sum of all rows up to and including
> >the current row and the current row changes as you go down the table.  I
> >seem to remember there isn't an easy way to code this in most
> >spreadsheets.
> >
>
> The spreadsheet will change the formula to the correct one for you.
> Just select the last cell in your balance column and copy it to the
> clipboard.  Then select the cell immediately under that cell and
> drag it down the number of lines necessary to match the number of
> entries you will make.  Then set the spreadsheet to move one cell to
> the right when hitting the enter key.  When you have entered all the
> lines date hit down arrow then home and you will be at the start of
> a fresh line ready to enter more data.
>

I think you have just explained why I find a spreadsheet solution to
this rather 'uncomfortable'!  All those actions required just to add one
new entry?!?!?

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Chris Green]

On Wed, Jun 13, 2012 at 11:58:10AM -0400, Jake Maier wrote:
> Another option is to use a database program, but those are more
> sophisticated to operate.

I have a couple of database solutions, one using a Wiki as the place to
enter values and show output.  However the database approach doesn't
really address the data entry requirement very well, at present I use
the Wiki but I'd like a cleaner and easier approach.


> What about a financial program? GnuCash is great, free and will do what you
> want and even will do things you may want to do in the future.

I'll take a look at GnuCash, I've looked at it before for other things
but not with this in mind, thanks.

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Jim Byrnes-4]

On 06/14/2012 12:07 PM, Chris Green wrote:

> On Wed, Jun 13, 2012 at 10:52:43AM -0500, Jim Byrnes wrote:
>> On 06/13/2012 04:38 AM, Chris Green wrote:
>>>>
>>>> a spreadsheet is probably the best solution.  If you enter the formula
>>>> in the top cell of the running balance column yoiu can use the drag
>>>> handle to automatically enter the appropriate formula in all the cells
>>>> below it; you don't need to enter the formula in each cell manually.
>>>>
>>> But the cells aren't there below it until the 'next line' has been entered.
>>>
>>> I don't want a huge table of emptiness with just a few rows and columns
>>> with data in them (as seems to be the norm with most Spreadsheet use I
>>> have seen).
>>>
>>> When there are (say) eight debit/credit entries in my table I just want
>>> to see eight rows in the spreadsheet with (probably) just three or four
>>> columns.
>>
>> In that case turn off the display of grid lines so unused cells are
>> not shown.  Then if you know how many entries you will have to make
>> just copy your formula to that many lines.
>>
> But I don't know how many entries there will be - do you know how many
> lines there will be on your bank statement next April?  :-)

No, but you will when you have your bank statement in front of you. I
actually do what you want to do, only I download my bank trasactions as
a csv file and cut and paste them into my spreadsheet in one operation.

>>> If I understand you correctly you are saying one should copy the formula
>>> for the running balance into the Balance column for lots of columns into
>>> the future - is this right?
>>>
>>> Another issue is that the formula is *different* for the running balance
>>> as you go down isn't it as it's the sum of all rows up to and including
>>> the current row and the current row changes as you go down the table.  I
>>> seem to remember there isn't an easy way to code this in most
>>> spreadsheets.
>>>
>>
>> The spreadsheet will change the formula to the correct one for you.
>> Just select the last cell in your balance column and copy it to the
>> clipboard.  Then select the cell immediately under that cell and
>> drag it down the number of lines necessary to match the number of
>> entries you will make.  Then set the spreadsheet to move one cell to
>> the right when hitting the enter key.  When you have entered all the
>> lines date hit down arrow then home and you will be at the start of
>> a fresh line ready to enter more data.
>>
> I think you have just explained why I find a spreadsheet solution to
> this rather 'uncomfortable'!  All those actions required just to add one
> new entry?!?!?
>

It's not just one entry it is for all of them in one operation.  The
point about setting how the spreadsheet moves from cell to cell was just
tom make data entry easier, as opposed to selecting each cell by
pointing to it with the mouse.  I think if you open up your spreadsheet
and try it with some test data you will see it is not as bad as it sounds.

Regards,  Jim




--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Chris Green]

On Thu, Jun 14, 2012 at 06:10:37PM +0100, Chris Green wrote:
> > What about a financial program? GnuCash is great, free and will do what you
> > want and even will do things you may want to do in the future.
>
> I'll take a look at GnuCash, I've looked at it before for other things
> but not with this in mind, thanks.
>
... and it doesn't do *anything like* what I want.

I want a simple ledger not a double-entry book-keeping program.

*All* I want is a way to enter debits and credits into a single
account/ledger and show the balance.  GnuCash is total overkill for this
and would insist on places to get money from, places to send money too,
a balancing transaction, etc.

What I want is to be able to do the following:-

2012-01-01      Initial Balance         100.00          100.00
2012-02-02      Buy hay                 -10.00           90.00
2012-02-10      Horsefeed               -47.50           42.50
2012-03-01      Payment from Fred        50.00           92.50

This is absolutely all I want, just a simple way to enter the above data
and present it as a table. (Well, I want the computer to calculate the
last column, the balance)

My ideal way of showing this would be a 'grid' on a web page which would
show a blank row below the last entry into which one could type the next
row of data.  I can produce something like this in MS Access but would
prefer Open Source and Web based if possible.

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Chris Green]

On Thu, Jun 14, 2012 at 12:39:39PM -0500, Jim Byrnes wrote:
> >But I don't know how many entries there will be - do you know how many
> >lines there will be on your bank statement next April?  :-)
>
> No, but you will when you have your bank statement in front of you.
> I actually do what you want to do, only I download my bank
> trasactions as a csv file and cut and paste them into my spreadsheet
> in one operation.
>
This isn't actually a bank reconcilitation, there's no place to copy the
transactions from.  It's a very simple income/expense account for
keeping horses, I want to *create* a bank statement like report by
entering money coming in and going out related to the horses.

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Verde Denim]

On Thu, Jun 14, 2012 at 1:51 PM, Chris Green <[hidden email]> wrote:

On Thu, Jun 14, 2012 at 12:39:39PM -0500, Jim Byrnes wrote:
> >But I don't know how many entries there will be - do you know how many
> >lines there will be on your bank statement next April?  :-)
>
> No, but you will when you have your bank statement in front of you.
> I actually do what you want to do, only I download my bank
> trasactions as a csv file and cut and paste them into my spreadsheet
> in one operation.
>
This isn't actually a bank reconcilitation, there's no place to copy the
transactions from.  It's a very simple income/expense account for
keeping horses, I want to *create* a bank statement like report by
entering money coming in and going out related to the horses.

I'd suggest building this as it seems to be a simple ledger program.  If you can use something like Oo Base you could save a lot of time/resources. Otherwise, something like Python or Java would be useful for this and would not be complicated to build. I seem to remember seeing something like this for Linux years back, but not recently. You may try googling for "ledger application" or single entry accounting ledger and see if that gets you somewhat closer to what you're after. Sorry I couldn't be of more help.

-- Jack

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Jake Maier]

> -----Original Message-----
> From: [hidden email] [mailto:ubuntu-users-
> [hidden email]] On Behalf Of Chris Green
> Sent: Thursday, June 14, 2012 1:49 PM
> To: [hidden email]
> Subject: Re: Simple (web?) application for producing something like a
> bank statement - ideas?
>
> On Thu, Jun 14, 2012 at 06:10:37PM +0100, Chris Green wrote:
> > > What about a financial program? GnuCash is great, free and will do
> > > what you want and even will do things you may want to do in the
> future.
> >
> > I'll take a look at GnuCash, I've looked at it before for other
> things
> > but not with this in mind, thanks.
> >
> ... and it doesn't do *anything like* what I want.
>
> I want a simple ledger not a double-entry book-keeping program.
>
> *All* I want is a way to enter debits and credits into a single
> account/ledger and show the balance.  GnuCash is total overkill for
> this and would insist on places to get money from, places to send money
> too, a balancing transaction, etc.
>
> What I want is to be able to do the following:-
>
> 2012-01-01      Initial Balance         100.00          100.00
> 2012-02-02      Buy hay                 -10.00           90.00
> 2012-02-10      Horsefeed               -47.50           42.50
> 2012-03-01      Payment from Fred        50.00           92.50
>
> This is absolutely all I want, just a simple way to enter the above
> data and present it as a table. (Well, I want the computer to calculate
> the last column, the balance)
>
> My ideal way of showing this would be a 'grid' on a web page which
> would show a blank row below the last entry into which one could type
> the next row of data.  I can produce something like this in MS Access
> but would prefer Open Source and Web based if possible.
>
> --
> Chris Green

Chris you don't need to do a double entry system when using GnuCash. You can
just use one ledger and enter exactly the data you listed here nothing more.
You will not get a balance for each entry history, but you will get the
total balance and I take it that is anyway what you want.
Installing the system costs you 1 minute and you can use any of the accounts
as a simple ledger and start putting in date, description and amount and
that's all. Underneath you always will see the balance.
You know if you have a 30 speed racing bike with speedometer, and clips and
all bells and whistles, you still can just as easily just push it as you can
a one speed walmart bike.
Excuse my stupid comparison but I couldn't think of a better one momentarily
:)
Jake


--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[NoOp-4]

On 06/14/2012 11:46 AM, Jake Maier wrote:
>
>
>> -----Original Message-----
...

>> I want a simple ledger not a double-entry book-keeping program.
>>
>> *All* I want is a way to enter debits and credits into a single
>> account/ledger and show the balance.  GnuCash is total overkill for
>> this and would insist on places to get money from, places to send money
>> too, a balancing transaction, etc.
>>
>> What I want is to be able to do the following:-
>>
>> 2012-01-01      Initial Balance         100.00          100.00
>> 2012-02-02      Buy hay                 -10.00           90.00
>> 2012-02-10      Horsefeed               -47.50           42.50
>> 2012-03-01      Payment from Fred        50.00           92.50
>>
>> This is absolutely all I want, just a simple way to enter the above
>> data and present it as a table. (Well, I want the computer to calculate
>> the last column, the balance)
>>
>> My ideal way of showing this would be a 'grid' on a web page which
>> would show a blank row below the last entry into which one could type
>> the next row of data.  I can produce something like this in MS Access
>> but would prefer Open Source and Web based if possible.
>>
>> --
>> Chris Green
> Chris you don't need to do a double entry system when using GnuCash. You can
> just use one ledger and enter exactly the data you listed here nothing more.
> You will not get a balance for each entry history, but you will get the
> total balance and I take it that is anyway what you want.
> Installing the system costs you 1 minute and you can use any of the accounts
> as a simple ledger and start putting in date, description and amount and
> that's all. Underneath you always will see the balance.
> You know if you have a 30 speed racing bike with speedometer, and clips and
> all bells and whistles, you still can just as easily just push it as you can
> a one speed walmart bike.
> Excuse my stupid comparison but I couldn't think of a better one momentarily
> :)
> Jake
>
>

Yep.
http://www.gnucash.org/features.phtml

And for a very simple Intuit type:
http://homebank.free.fr/

But I prefer gnucash.



--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Chris Green]

On Thu, Jun 14, 2012 at 02:02:56PM -0400, Verde Denim wrote:

>    On Thu, Jun 14, 2012 at 1:51 PM, Chris Green <[1][hidden email]> wrote:
>
>      On Thu, Jun 14, 2012 at 12:39:39PM -0500, Jim Byrnes wrote:
>      > >But I don't know how many entries there will be - do you know how
>      many
>      > >lines there will be on your bank statement next April?  :-)
>      >
>      > No, but you will when you have your bank statement in front of you.
>      > I actually do what you want to do, only I download my bank
>      > trasactions as a csv file and cut and paste them into my spreadsheet
>      > in one operation.
>      >
>      This isn't actually a bank reconcilitation, there's no place to copy the
>      transactions from.  It's a very simple income/expense account for
>      keeping horses, I want to *create* a bank statement like report by
>      entering money coming in and going out related to the horses.
>
>    I'd suggest building this as it seems to be a simple ledger program.  If

Exactly - it's a ledger, however searching for 'ledger' always produces
loads of high-powered accounting programs.


>    you can use something like Oo Base you could save a lot of time/resources.

Yes, I'm wondering if OpenOffice/LibreOffice will do what I want.


>    Otherwise, something like Python or Java would be useful for this and
>    would not be complicated to build. I seem to remember seeing something
>    like this for Linux years back, but not recently. You may try googling for
>    "ledger application" or single entry accounting ledger and see if that
>    gets you somewhat closer to what you're after. Sorry I couldn't be of more
>    help.

You have at least understood *exactly* what I want.  I suspect I may end
up writing something in Python.

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Verde Denim]

Chris
Since I'm busy looking for work I'm a bit limited, but I'll have a look and see if I can come up with an idea or two on how to put something simple together using Oo and Py... Not sure of your level of code development so let me know if you've got a preference...

-- Jack

On Jun 14, 2012 5:25 PM, "Chris Green" <[hidden email]> wrote:

On Thu, Jun 14, 2012 at 02:02:56PM -0400, Verde Denim wrote:
>    On Thu, Jun 14, 2012 at 1:51 PM, Chris Green <[1][hidden email]> wrote:
>
>      On Thu, Jun 14, 2012 at 12:39:39PM -0500, Jim Byrnes wrote:
>      > >But I don't know how many entries there will be - do you know how
>      many
>      > >lines there will be on your bank statement next April?  :-)
>      >
>      > No, but you will when you have your bank statement in front of you.
>      > I actually do what you want to do, only I download my bank
>      > trasactions as a csv file and cut and paste them into my spreadsheet
>      > in one operation.
>      >
>      This isn't actually a bank reconcilitation, there's no place to copy the
>      transactions from.  It's a very simple income/expense account for
>      keeping horses, I want to *create* a bank statement like report by
>      entering money coming in and going out related to the horses.
>
>    I'd suggest building this as it seems to be a simple ledger program.  If

Exactly - it's a ledger, however searching for 'ledger' always produces
loads of high-powered accounting programs.


>    you can use something like Oo Base you could save a lot of time/resources.

Yes, I'm wondering if OpenOffice/LibreOffice will do what I want.


>    Otherwise, something like Python or Java would be useful for this and
>    would not be complicated to build. I seem to remember seeing something
>    like this for Linux years back, but not recently. You may try googling for
>    "ledger application" or single entry accounting ledger and see if that
>    gets you somewhat closer to what you're after. Sorry I couldn't be of more
>    help.

You have at least understood *exactly* what I want.  I suspect I may end
up writing something in Python.

--
Chris Green

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users