Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Hi :)
Ahh, just had a quick look at a set of accounts and noticed that b/fwd and
c/fwd ARE used the logical way around.  For some reason i've always thought
they were counter.

So the c/fwds figures ARE at the bottom of the sheet and show the
sub-totals of that sheet.  The b/fwds figures ARE at the top of the new
sheets.

Phew!
Regards from
Tom :)




On 7 December 2014 at 13:36, Tom Davies <tomcecf@gmail.com> wrote:

Hi :)
Spreadsheets are not really made to be good at accounting and
bookkeeping.  GnuCash or other dedicated programs might be better.
Spreadsheets are designed to do a lot of calculations.

So, spreadsheets ARE great for doing "working papers" such as to;
*  "reconciliations" (although the dedicated bookkeeping programs would
still probably be better) usually "bank reconciliations" although there
might be other types of accounts that need reconciling against each other
to check both sets of records are in sync and correctly acknowledge
outstanding items.
*  VAT or tax calculations
*  preparation for "End of Year" accounts and /or management accounts


Generally in bookkeeping if you get near the end of a page, or at a
convenient point (say at the end of a month) then you do all the subtotals
as "brought forwards" (seems like the wrong term but it's the one used in
bookkeeping and accountancy) often shortened to "b/f" or "b/fwds".  Then at
the top of the new page/sheet you have those same figures copied in as
"carried forwards" or "c/f" or "c/fwds".  In spreadsheets those carried
forwards values can be set as formulas so that if the b/fwds figures change
then those changes ripple through the whole set of accounts.  That makes it
easier for bookkkeepers but it's a nightmare for accountants.



It sounds like you are trying to set-up 2 new systems to cross-check
against each other.  This sounds like a complete nightmare and likely to
create tons of trouble.  Using spreadsheets for accounting or bookkeeping
takes a lot of time and resources to set-up.  If you really need to run 2
different systems at the same time then it's probably better to just keep
the old system going rather than to pour resources into setting up a 2nd
different one that you also can't be completely confident about!

Also it's a good idea to get a specialist in to help.  An experienced
bookkeeper might be able to set-up something workable in spreadsheets much
more quickly than someone who is not trained in accounts.  There are a LOT
of potential pitfalls they are probably used to dodging (although i know of
a few they usually miss).
Regards from
Tom :)




On 7 December 2014 at 13:12, Wiebe van der Worp <w@vanderworp.org> wrote:

First post, not sure it is the right place, hi there!

For 2015 I would like to keep a shadow bookkeeping in Calc in order to
check our bookkeeping program for a while.

Input: In order to keep things simple: three columns with Description,
Amount and a LedgerCode.

Output: Sums per LedgerCode

Several solutions are thinkable of, such as conditional testing and
lookups. However, if the list grows and contains thousands of lines it will
influence performance.

The question: What is the most efficient approach in order to keep the
sheet alive after adding record 2384?

Example:
LedgerCode: 1, 2, 3
-------------------
1       € 100,00
2       € 65,00
3       € 22,00
-------------------
Description     Amount  LedgerCode
booking 1       € 100,00        1
booking 2       € 50,00 2
booking 3       € 20,00 3
booking 4       € 10,00 2
booking 5       € 5,00  2
booking 6       € 2,00  3



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.