We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

How good are Googledocs spreadsheets for basic accounting

Options
WLM21
WLM21 Posts: 1,599 Forumite
Part of the Furniture 500 Posts Combo Breaker
I have an old compute with Excel 2002 installed which I am very familiar with, meaning I can do most things I ever have to on any spreadsheet.

I have been asked to help somebody do some basic accounting, nothing fancy just the usual sales / expenditure details.

I was wondering how good the spreadsheets are on Googledocs. I have never used them before but had a quick look online last night to get a few facts and figures.

There is a limit of 15GB memory, but how big is this. Say I had a spreadsheet of 15 columns, with 10 lines of data for every day .. how big would the file be at the end of the year.

I wouldn't have a problem with my Excel 2002, but I'll be getting a new computer soon, which would mean using the updated version of Excel. I would have to buy that too and that'll not be cheap no doubt.

Would I be just better off using Googledocs

thank you

Comments

  • Sooler
    Sooler Posts: 3,113 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    WLM21 wrote: »
    There is a limit of 15GB memory, but how big is this.

    Huge
    WLM21 wrote: »
    Say I had a spreadsheet of 15 columns, with 10 lines of data for every day .. how big would the file be at the end of the year.

    Tiny

    Consider this
    https://www.openoffice.org/product/calc.html
  • bingo_bango
    bingo_bango Posts: 2,594 Forumite
    Either Google Docs or OO as Sooler explained.

    In terms of what size the file will be, I currently have 577 spreadsheets on my PC, with an average size of ~150Kb.

    Average workbook has 5 tabs, each with 15 columns and about 350 lines of data. Total size for all 577 books is about 90Mb.

    You'd be a long time hitting the 15Gb Google limit. By my reckoning, each of your 1 year worksheets would be around 180Kb max. You therefore would have room for ~100,000 years worth of data on Google Docs.

    Bear in mind also that if this is a package for someone else, it is much easier to set it up on a google account that they can access, rather than a standalone copy on your PC which you will then have to update for them.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.8K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.8K Work, Benefits & Business
  • 598.6K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 257.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.