On-the-Job Training Daily Journal

1	April	8		I scanned, segregated, arranged, tallied, totaled, and checked the Coop’s MIGS dividend vouchers specifically the vouchers in Makilala and South Skyland Valley.  MIGS means Members In Good Standing. Day 1 Supervisor: Mr. Aries S. Villa
2		11		Their pawnshop opened a new accounting database—Quickbooks Pro 2013.   They made me its operator specialist.  I reviewed the mechanics, shortcuts, features, and specialties of the updated database.  My major goal is to convert everything from legacy system to quickbooks database.  Later that day, I started encoding the transactions of Period 1.
3		12		I continued encoding and assessing the transactions in Quickbooks—Period 1.
4		13		Morning—I finished encoding Period 1 and proceeded in Period 2 Afternoon—Investigated and assessed the rest of the transactions from Period 1 to Period 2 and cross referred the transactions from MS Excel copies to hard copies to Quickbooks and vice versa.
5		15		I continued checking customer payments and the sales receipt through hard copies, MS Excel copies and Quickbooks copies.
6		16		I checked and wrote the new pawn ticket numbers in the receipts of old ones to have an ease of encoding the transactions in the database (standard operating procedure).  After I finished checking the receipts, I commenced encoding the Period 3 transactions.
7		17		…continued encoding and checking Period 3 transactions
8		18		Morning—…audited the transactions again in Period 1. Afternoon—Checked and continued encoding Period 3 transactions.
9		19		Morning—finished encoding and assessing Period 3 transactions Afternoon—audited 2012 transactions encoded by the office staffs.
10		20		Reconciled the balance sheet made through conventional system with the balance sheet made by the database… scanned through inventories record in excel, masterlists, LERs and other hard copies. …find and correct some errors—mostly errors on dates, pawn ticket numbers and mismatching receipts of the customers(members).
11		22		…searched for the 207 pesos overvalued amount in Loans and Pledges account
12		23		…found the errors and balanced the QuickBooks balance sheet and conventional balance sheet. Day 2 to 12 Supervisors:  Ms. Emily C. Magallon & Ms. Gennifer S. Gadian
13		24		I was assigned in processing department because the staffs at DECCO Pawnshop went to a seminar. I printed checks and members’ loan ledgers, sorted and clipped the checks and ledgers to their respective members’ documents, and filed and alphabetized all afterwards. I continued encoding period 4 transactions in Quickbooks when the pawnshop staffs arrived at late afternoon. Day 13 Supervisor:  Ms. Mary Ann T. Genova
14		25		…continued the transactions in Period 4
15		26		I reconciled Period 1 income statement in Quickbooks and Period 1 income statement in conventional system; adjusted some accounts and corrected some errors; and investigated the rest of the suspicious amounts shown in the database. I have successfully reconciled some of the accounts but had a big problem with one account having a substantial difference compared to conventional records.
16		27		I continued reconciling the two income statements; corrected some errors and added some un-encoded sales receipts that correspond to each new pawn tickets in Period 1 2013. …reviewed the LER(Loan Extension Register) for some 2012 transactions that were paid in Period 1
17		29		The income statements were still not balanced…  I requested for more source documents.  I investigated and cross referenced their cash vouchers, official receipts, daily liquidation and LERs. This afternoon, I checked withdrawal slips to make them easy for clients(members) to fill them up.
18		30		I continued reconciling the two income statements… this time, I found some gray areas in their replenishment records.  My supervisors and I were thinking were to place the deficit found on the records, and why would we recognize it.  We had all day finding other gray areas that could help us solve the problem.
19	May	2		…continued reconciling the two income statements …reformulated the entries in period 1 2013 in Quickbooks At the end of the day, I finished encoding Period 1 in new formed transactions and found out that the some accounts now exceeded the accounts in conventional system… one factor would be the redundant transactions that were not yet deleted because of sudden brownout.
20		3		DECCO’s electricity wirings were badly detached because of some unknown reasons that were why I literally do not have the Quickbooks to operate with.  Therefore, I helped the staffs pack the giveaways and the groceries for their annual general assembly in Malaybalay, Bukidnon; I straighten the fattener wires to lessen my boredom. Later this day, I computed some parts of the ORs hoping to find out what made the latest update in quickbooks income statements higher that in conventional system.
21		4		…no electricity still.  I volunteered getting fasteners from old folders.  Imagine how many were the folders that took me 8 hours to finish arranging.
22		5		I straighten the fasteners and arrange some papers in alphabetical order… all day. The wire was fixed late afternoon, so I decided not to continue the Quickbooks yet.
23		7		I continued perfectly reconciled the Income statements.  My next problem was to reconcile the Period 1 Balance Sheets.  I investigated the overvalues and undervalues in all possible source documents the Pawnshop has. I gave up in balance sheets and continued with Period 2 income statements… before that, I reentered and edited other period 2 errors…
24		8		This morning, I stopped editing period 2 transactions, continued reconciling the Period 1 balance sheets with my supervisors, and ended up discovering more discrepancies.  I adjusted some errors and still the sheets were not reconciled.  My supervisors and I worked hand on hand to find what made the two balance sheets impossibly not reconciled. Afternoon—I continued period 2 and finished it afterwards… I started reconciling the period 2 income statements.  The LERs and LPRs rhymed with quickbooks but the conventional income statement did not.
25		9		Still period 2 income statements are not balanced so I decided to rest from investigating and continue inputting period 3 transactions.  I finished period 3 that day and I attempted to reconcile period 3 income statements.  There were accounts that were balanced and there were accounts that were not so I began investigating the transactions and cross-referenced those transactions with the source documents.  I decided to go to the processing office and helped them "checkwrite".
26		10		I continued encoding and editing Period 5 transactions…
27		11		I finally equaled the conventional balance sheet 2013 period 1 to quickbooks balance sheet 2013 period 1.
28		14		I commenced reconciling period 2 balance sheet and have reconciled it this day… however, the two income statements are not equal, that is why I investigated the period 2 transactions again… I have not found any errors in quickbooks as supported by all source documents.
29		15		I decided to reconcile period 3 balance sheets and found many errors in dated and in amounts… at the end of the day, I balanced them; But its income statement remained a mystery.
30		16		I commenced encoding, adjusting, and paying attention to the rest of period 5.
31		17		I continued encoding and auditing period 5.