Spreadsheet: 768719d1645098815-amount-not-pulling-through-pivot-table-2022-01-pettycash
Sheet: TABLES

 |  |  | CEVA ANIMAL HEALTH (PTY) LTD
TABLES USED ON EXPENDITURE WORKSHEET
LEDGER ACCOUNT CODES
 |  | 420200 | STAFF LOANS
 |  | 445500 | [NAME]
 |  | 467300 | SALARY CONTROL
617010 - VET SERVICES PRODUCT TESTING |  | 617010 | VET SERVICES PRODUCT TESTING
 |  | 623000 | ADVERTISING & PROMOTIONS
 |  | 628230 | ANNUAL & MEMBERSHIP FEES
 |  | 622100 | AUDIT FEES
 |  | 627000 | BANK CHARGES
 |  | 623020 | BROCHURES
 |  | 621100 | CASUAL WAGES
 |  | 628110 | CLEANING
 |  | 622700 | COMMISSION - DISTRIBUTORS
 |  | 628120 | COMPUTER SOFTWARE EXPENSES
 |  | 623310 | CONFERENCES
 |  | 622600 | CONSULTING FEES
 |  | 628130 | CONSUMABLES
 |  | 627200 | Debt issuance fees
 |  | 623010 | DESIGN & LAYOUT
 |  | 622400 | DEVELOPMENT COSTS - BIO
 |  | 622300 | DEVELOPMENT COSTS - PHARMA
 |  | 623410 | DONATIONS
 |  | 611210 | ENTERTAINMENT
 |  | 615060 | EQUIPMENT NOT CAPITALISED
 |  | 623300 | EXHIBITIONS
 |  | 628240 | FINES
 |  | 624300 | Freight charges within group
 |  | 624200 | FREIGHT OUTWARDS
 |  | 624201 | FREIGHT - EXPORTS
 |  | 628000 | GENERAL EXPENSES
 |  | 623400 | GIFTS
 |  | 616000 | INSURANCE
 |  | 661000 | INTEREST PAID
 |  | 622200 | LEGAL COSTS
 |  | 637020 | LEVIES - GENERAL
 |  | 637000 | LEVIES - SKILLS DEVELOPMENT
 |  | 624210 | MOTOR VEHICLE EXP - DISTRIB
 |  | 625000 | MOTOR VEHICLE EXPENSE
 |  | 613010 | MOTOR VEHICLE HIRE
 |  | 628220 | MOVEMENT COSTS
 |  | 654020 | OVERS & UNDERS
 |  | 603210 | PACKAGING - C.O.S.
 |  | 602100 | PACKAGING - EXPENSE
 |  | 631000 | Payroll taxes
 |  | 628140 | PEST CONTROL
 |  | 626000 | POSTAGE
 |  | 628150 | PRINTING & STATIONERY
 |  | 623320 | PRODUCT LAUNCH
 |  | 628010 | PRODUCT TESTING
 |  | 605000 | PRODUCTION COSTS
 |  | 628160 | PROTECTIVE CLOTHING
 |  | 601000 | Purchase of raw materials
 |  | 605010 | PURCHASES - NON STOCK
 |  | 637010 | RATES & TAXES
 |  | 628400 | RECRUITMENT FEES
 |  | 622510 | REGISTRATION FEES - BIO
 |  | 622500 | REGISTRATION FEES - PHARMA
 |  | 613020 | RENT - EQUIPMENT
 |  | 615000 | REPAIR & MAINT - BUILDINGS
 |  | 615010 | REPAIR & MAINT - COMPUTERS
 |  | 615020 | REPAIR & MAINT - FURNITURE
 |  | 615030 | REPAIR & MAINT - PLANT&EQUIP
 |  | 615040 | REPAIR & MAINT - VEHICLES
 |  | 618400 | Sales & market data purchasin
 |  | 622800 | Sales commission - agents
 |  | 623600 | SAMPLES
 |  | 628170 | SECURITY EXPENSES
 |  | 618500 | SEMINARS
 |  | 615050 | SPARE PARTS USED
 |  | 623030 | SPONSORSHIPS
 |  | 628200 | STAFF WELFARE
 |  | 603420 | STOCK DISPOSAL
 |  | 628180 | SUBSCRIPTIONS
 |  | 626010 | TELEPHONE
 |  | 622610 | TRADE MARK REGISTRATIONS
 |  | 628190 | TRAINING & DEVELOPMENT
 |  | 625010 | TRAVEL FOREIGN 3RD PARTIES
 |  | 625030 | TRAVEL FOREIGN CAR HIRE
 |  | 625040 | TRAVEL FOREIGN FLIGHTS
 |  | 625020 | TRAVEL FOREIGN HOTELS
 |  | 625050 | TRAVEL LOCAL 3RD PARTIES
 |  | 625070 | TRAVEL LOCAL CAR HIRE
 |  | 625080 | TRAVEL LOCAL FLIGHTS
 |  | 625060 | TRAVEL LOCAL HOTELS &
 |  | 625060 | TRAVEL LOCAL HOTELS & MEALS
 |  | 622410 | TRIALS - BIO
 |  | 622310 | TRIALS - PHARMA
 |  | 666010 | FIN - FOREX - REALISED
628100 - REFUSE REMOVAL |  | 628100 | REFUSE REMOVAL
COST CENTRES
 |  | 000 | BLANK
 |  | 110 | [NAME] PARTIES LOCAL
 |  | 120 | [NAME] PARTIES EXPORT
 |  | 220 | UNAPPLIED PRODUCTION COST
 |  | 225 | QUALITY CONTROL & LABORATORY
 |  | 260 | SUPPLY CHAIN EXPENSES
 |  | 270 | INVENTORY DEPRECIATION AND WRI
 |  | 280 | [NAME] EXPENSES
 |  | 285 | [NAME]
 |  | 305 | GENERAL MANAGEMENT DIRECTION
 |  | 310 | CUSTOMER SERVICE RELATIONSHIP
 |  | 320 | COMMERCIAL EXP: DIRECT SELLING
 |  | 340 | MARKETING & ADVERTISISNG
 |  | 345 | VETERINARY SERVICES
 |  | 350 | IN OVO VACCINATION SERVICES
 |  | 355 | DAY OLD & FARM VACCINATION SERVICES
 |  | 360 | GENERAL & ADMINISTRATIVE EXP
 |  | 380 | RESEARCH EXPENSES PHARMA
 |  | 390 | RESEARCH EXPENSES BIO
 |  | 516 | FINANCIAL FOREX GAINS / LOSSES
DIVISIONS
000 - BLANK
PET - COMPANION ANIMALS
POU - POULTRY
RUM - RUMINANT
SWI - SWINE
OTH - OTHER
NAP - NOT APPLICABLE
EMPLOYEES
000 - BLANK
P35 - DEENAN MOODALEY
R01 - MARIUS VILJOEN
P18 - [NAME]
P25 - RIANDA DU RANDT
R17 - WILLEM SCHULTHEISS
R52 - RUANDA BAAK
P14 - ATTIE VENTER
P17 - THERESA-MARIE MAREE
P19 - KOBUS BRITZ
P22 - CAITLIN OOSTHUIZEN
P23 - NEW KEY ACCOUNT MANAGER
R20 - RUMINANT REPS - DO NOT USE
R50 - ADRIAAN VAN DER WESTHUIZEN
R34 - ANDRIES GUNTER
R40 - DEON DE JAGER
R38 - ERWIN STRUBING
R49 - FILECIA SINDEN
R47 - JAN-HENDRIK ZIETSMAN
R25 - JOHN LITTLEFIELD
R48 - MICHAEL BEZUIDENHOUT
R15 - PIETER CONRADIE
R44 - RIAAN OBERHOLZER
R36 - RIAAN VERMEULEN
R51 - STEPHAN STEENKAMP
P34 - ALBA PFAFF
P20 - CHANTAL JACA
P21 - CHRISTO VISAGIE
P15 - CHRIS VAN BILJON
P26 - AYANDA MKHWANAZI
P27 - GIVEN MALETE
P28 - JOHAN VOSLOO
P29 - JOHANN DU RANDT
P30 - JOHN MOKGOTLA
P31 - LONDIWE MTHETHWA
P32 - MAXWELL FAKUDE
P33 - NICKY VAN DER MERWE
P24 - STIAAN SNYMAN
[NAME]
P37 - ELZET RUSCH
R53 - HANNELIE CILLIERS
R54 - NICKY SCHOLTZ
P39 - MARUCHELLE CILLIERS
R55 - THANDIWE MTIMKULU
P44 - JASON BRESSLER
SUB-LEDGER
BW - BOTSWANA
FR - FRANCE
MW - MALAWI
NA - NAMIBIA
SZ - SWAZILAND
ZA - SOUTH AFRICA
ZM - ZAMBIA
ZW - ZIMBABWE