function help
Are you reconciling in total? Maybe a layout like this? You would have to
leave enough space for the users to input the individual Debit/Credit items.
I'm struggling a little with how the users are having problems w/reconciling
an account balance. How do they manage their checkbooks?
Debit Credit Balance
100
400
200
Total 300 400 100
Per G/L 150
Variance -50
Where Balance = ABS(TotalDebits - TotalCredits) unless you want the users to
input accounts that have a credit balance per the G/L as negative amounts,
then leave out the ABS function.
"angela" wrote:
Yes, but I'm just not sure how to build this spreadsheet for helping the
users reconcile the amounts. Suggestions?
--
angela
"JMB" wrote:
There is, and it is (ironically) called SUM. Check Excels help for details
on how to use.
"angela" wrote:
Hi Community~
I need to create a spreadsheet to help non-technical users to reconcile
expenses (checks) and revenue to a general ledger account. Simple for me as
an accountant but I'm struggling on how to make it EASY for users who aren't
accountants and don't know Excel. Is there a SUM function or anything else I
could build in the sheet?
Simple spreadsheet is:
Date Description (ck# perhaps) Expense$ (Debit) Income$(Credit)
Users need to reconcile this spreadsheet to a specific general ledger
account and they should be identical. If not, they research discrepancies.
Any suggestions would be appreciated!
--
angela
|