Imports / Captures

Accounting

February 2022

1. Capture: Customer Invoices - https://drive.google.com/file/d/1DEkcn73VpgmBtGOOWqOt4pzNaBJ49TPQ/view?usp=sharing

   • Capture these transactions as Customer Invoices in QE. Note the INA numbers which are important for the client to see. 

2. Capture: Supplier invoices - https://drive.google.com/file/d/1sB4ADKSNoBOH5bSgo7cW6JcPUx0WukUh/view?usp=sharing 

   • Capture these transactions as Supplier Invoices in QE. Note the PN numbers which are important for the client to see. 

3. Capture: Journals - https://docs.google.com/spreadsheets/d/1oZTIHxHwJyM8S6KUEeIVUr8ypZ5kWJHm/edit?usp=sharing&ouid=108350635124705985413&rtpof=true&sd=true 

   • General Journals

   • Payroll Journals

   • Depreciation Journals

   • Accruals

   • Sales

   • Purchases

   • Purchase Returns

   • Supplier Journals

4. Capture: GL Detailed Ledger - https://docs.google.com/spreadsheets/d/1yGKHkjiD4WnVUD_Jf5z7h8UkmWO7tPk6/edit#gid=529187993 

5. TBC: Trial Balance (Jan - Feb) - https://docs.google.com/spreadsheets/d/1OIT-fNeszOHNI4jAY-Pp0wQdNSfyZtYX/edit?usp=sharing&ouid=108350635124705985413&rtpof=true&sd=true 

March 2022

1. Capture: Supplier Invoices - https://drive.google.com/file/d/1h_HaVFn__BNDlcDIsIn5SO14CtTwLRrk/view?usp=sharing

   • Capture these transactions as Supplier Invoices in QE. Note the PN numbers which are important for the client to see. 

2. Capture: Outstanding GRNs in Supplier Sequence - https://drive.google.com/file/d/1RIWi5ufk-DkVCGT_L_jRQgnMRn5VCeCV/view?usp=sharing 

   •  GN are Goods Received Notes

   • Capture Good Received Transactions

     1. GR Number in QE:  Document Number: GN152789

     2. GR Date

     3. Item / Product

     4. Qty

     5. Unit Price. If there is no value, capture the value zero

     6. Reference example: INV0000254 or AMR-S32/00295