Pay Reconciliation
 

G'day there One & All,

I've put my current Excel/Word project on hold to work on a
problem of my own. I may not be thanked for it at the office, but from
my perspective things are kind of reversed :).

I'm trying to reconcile my pay records for the last 4 years. I'm
paid fortnightly, so there are only 26 sets of records pa.

The basic concept is simple, compare what I've claimed against
what I've received and note differences. However it's not as simple as
rows for each pay day and columns for each category (standard hours,
overtime, shift allowance, etc).

I get paid a fortnight ahead for standard hours, but since
they're "standard" then it's the same each fortnight anyway except for
annual leave or sick leave. What's causing my confusion is that we get
paid penalties and overtime about 4 weeks later. Hence what's coming in
each fortnight bears no relationship to what I've claimed in that
fortnight.

It's not that difficult to set up references to rows 2 or 3 above
for previous fortnights, but on the few times I've tried to set
something up I always find some difficulty that prevents me from
automates what I'm doing. I know it's only a matter of persistence till
I can organise everything but I was hoping that someone may have
resolved a similar problem and may have some advice or perhaps a sample
sheet/code already working. I'm not good with repetitious figures (hence
I'm not an accountant) and trying to get this to work is making my head
hurt.

I've searched the web for freebie examples, but the few I've
found aren't appropriate and the authors have, quite rightly, locked
their code. At the moment my head is hurting so I'm off to make a Chai
Tea and watch TV for a bit.

Anyone who can offer ideas to tame this concept will certainly
find a welcome ear.

Thanks for listening
Ken McLennan
Qld Australia