Stock Transfer Ledger - Excel by cqy28049

VIEWS: 689 PAGES: 13

More Info
									                                                       Company Name
                                             Accounts Payable Processing Checklist

Daily/Weekly Procedures
1. Enter Invoices
2. Enter Credit Notes
3. Enter Manual Payments as required.
4. Process Payment Runs as required.
5. Daily Backup
6. Run Creditors End of Day

Monthly Procedures
                                             Jul    Aug     Sep       Oct   Nov   Dec    Jan    Feb     Mar    Apr    May    Jun

1. Complete daily activities
   (1-5).

2. Process Payment Runs as required.

3. Print Detailed Trial Balance,
   and check balances.

4. Print Transaction Reports.

5. Print Payment Cashflow Report.

8. Re-index all data files.

9. Take Backup-Monthly.

10. General Ledger Transfer.

11. Run End of Month.


Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year.
3. Take a backup (yearly disks).
4. Run End of Year.




                                                                             Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                            Page 1
                                                                                    G:\Data Storage\Processing Checklists\Nexus.xls
                                  Company Name
                            Automatic Payment Procedures

1.   Ensure that all invoices and credit notes are entered.

2.   Print Trial Payment Selection and check that all items to be paid are listed.

3.   Place items on hold if they are not to be paid.

4.   Repeats steps 2 and 3 as often as required.

5.   Confirm selection with Payment Selection Run.

6.   Print Remittance Advices.

7.   Print Cheques as required .
     (At least print to screen to allocate cheque numbers for cashbook)




                                                                    Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                   Page 2
                                                                           G:\Data Storage\Processing Checklists\Nexus.xls
                                                    Company Name
                                         Accounts Receivable Processing Checklist

Daily/Weekly Procedures
1. Enter stock receipts
2. Enter sales orders & Direct
3. Run backorder report
4. 'Direct' sales order where stock has since been received
5. Enter cash sales via stock invoice entry
6. Enter account receipts via debtors cash receipts entry
7. Print banking summary
8. Run Debtors end of day
9. Print reports required - detailed list yet to be finalised

Monthly Procedures
                                      Jul    Aug     Sep        Oct   Nov   Dec    Jan    Feb    Mar     Apr    May    Jun

1. Complete daily activities
   (1-8).

2. Print Detailed Trial Balance,
   and check balances.

3. Print Statements.

4. Print Sales Tax Report.

5. Print Transaction Report.

6. Print Transaction
   Dissection Report.

7. Print saleman reports

8. Re-index all data files.

9. Take Backup-Monthly.

10. Run End of Month.


Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year.
3. Take a backup (yearly disks).
4. Run End of Year.



                                                                            Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                          Page 3
                                                                                  G:\Data Storage\Processing Checklists\Nexus.xls
                                                          Company Name
                                                  Fixed Asset Processing Checklist

Daily/Weekly Procedures
1. Enter Asset Purchase as required.
2. Asset Maintenance as required.
3. Enter Asset Disposal as required.
4. Take backup with daily disks.

Monthly Procedures
                                                Jul     Aug    Sep    Oct   Nov    Dec     Jan    Feb    Mar     Apr    May    Jun

1. Complete daily activities
   (1-4).

2. Re-index all data files.

3. Take Backup-Monthly.

4. Run Depreciation update for month.

4. Print Depreciation Schedule.

7. Print Other Reports as required.




Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year. (1-7)
3. Take a backup (yearly disks).
4. Run End of Year.




                                                                                  Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                                 Page 4
                                                                                         G:\Data Storage\Processing Checklists\Nexus.xls
                                                         Company Name
                                                   Cashbook Processing Checklist

Daily/Weekly Procedures
1. Enter cashbook transactions.
2. Print bank deposit slips.
3. Enter bank statement details.
4. Daily Backup

Monthly Procedures
                                             Jul     Aug    Sep       Oct   Nov   Dec    Jan    Feb     Mar    Apr    May    Jun

1. Complete daily activities
   (1-4).

2. Print Bank Reconciliation Report.

3. Print Other Reports as required.

4. Re-index all data files.

5. Take Backup-Monthly.

6. General Ledger Transfer.

7. Run End of Month.


Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year.
3. Take a backup (yearly disks).
4. Run End of Year.




                                                                             Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                            Page 5
                                                                                    G:\Data Storage\Processing Checklists\Nexus.xls
                                                        Company Name
                                               General Ledger Processing Checklist

Daily/Weekly Procedures
1. Enter Journals, etc as required.
2. Post transactions as required.
3. Chart Re-Calculation and Revalidation as required.
3. Print Transaction Audit Trail - Standard Reports Menu.
4. Backup data.

Monthly Procedures
                                               Jul    Aug   Sep   Oct   Nov     Dec     Jan    Feb     Mar     Apr    May     Jun

1. Complete daily activities
   (1-4).

2. Re-index all data files.

3. Ensure that all data is transferred from
   Subsidiary Ledgers and posted.

4. Take Backup-Monthly.

5. Run Chart Re-Calculation & Validation
   - Processing Menu.

6. Run Validate & Reconsolidate Chart.
   - Setup & Utilities Menu.

7. Print Private Ledger Report.

8. Print Trial Balance.

9. Print Financial Reports.

10. Run End of Month.



Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year. (1-9)
3. Take a backup (yearly disks).
4. Run End of Year.




                                                                              Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                             Page 6
                                                                                     G:\Data Storage\Processing Checklists\Nexus.xls
                            Company Name
                            Payroll Processing Cycle

1. Payroll Creation

2. Edit Current Pay
    For Holiday Pays - record the number of periods on leave for. Accept the
    default and calculate the holiday tax on the normal hours.

3. Run the Employee Superannuation Calculation

4. Run the Taxation Calculation

5. Print the Current Payroll Listing by Employee and check for correct hours, etc.

When happy with the above:
6. Print the Payslips

7. Print Cheques / Coinage Analysis / Prepare the Bank Transfer

8. Take a backup.

9. End the Current Pay

10. Print the Taxation Report (note gross means gross taxable)

11. Print On Costs Report

12. Print the Sick Accrual Report

13. Print the Holiday Accrual Report

14. Print any other reports required

Month End Procedures
1. Complete pays for month

2. Transfer information to General Ledger

3. Take a Backup

4. Run End of Month



                                                                                   Prepared by Daniele Saunders & Parnters,
                                                                                                                      Page 7
                                                                                 G:\Data Storage\Processing Checklists\Nexus
Type: REvenue, EXpense, CApital, Current ASset, LIability, Fixed Asset
Nexus General Ledger Coding Sheet                 Usage: 0 Documentary; 1 Postable;
                                                         2 Sub-Account; 3 Sub-Total;
                                                         4 Total; 5 New Page
Company:                                                                                        Page:

Br Account No.    Description   Account   Usage   Link       Consolidation   Consolidation      Debit Credit
                                Type              Account    Branch          Account




                                                                         Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                        Page 8
                                                                                G:\Data Storage\Processing Checklists\Nexus.xls
                                                      Company Name
                                               Inventory Processing Checklist

Daily/Weekly Procedures
1. Complete daily procedures outlined on Accounts
   Receivable checklists.

Monthly Procedures
                                        Jul     Aug    Sep    Oct       Nov    Dec    Jan     Feb    Mar    Apr    May        Jun

1. Complete daily activities
   (as required).

2. Do stocktake, if required.
   (see attached).

3. Print Stock Valuation Report.

4. Print Stock Movement Report.

5. Take Backup, monthly disks.

6. Run End of Month.


Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year.
3. Take a backup (yearly disks).
4. Run End of Year.




                                                                      Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                    Page 9
                                                                            G:\Data Storage\Processing Checklists\Nexus.xls
                                             Company Name
                                         Markup Costing Proceedure

1. Setup stock control file to enable either markup costing or margins.
     (See pages 36 and 37 of the Diamond Series Stock Manual for a description of how each works.
2. Establish the markup/margin percentage on the stock maintenance screen (screen 3).
     Different percentages can be established for each selling price.
3. Go to the Stock Setup and Utilities Menu, Price/Cost Maintenance Programs.
4. Choose Option 4, Stock Price Update Using Margins.
5. Choose the combination of stock codes, prices and base costs to be updated.
     Always check the report for the results.




                                                            Prepared by Daniele Saunders & Partners, Confidential
                                                                                                         Page 10
                                                                  G:\Data Storage\Processing Checklists\Nexus.xls
             Company Name
          Stocktake Procedures


1. Complete processing up to stocktake date.
(i.e ensure all sales orders done and stock receipts done)

2. Take a backup.

3. Go to the Stocktake Processing Menu and print Stocktake Forms.

4. Stocktake Freeze/Unfreeze and enter the stocktake date.
   Enter through remainder of screen

5. Run option to 'Zero uncounted items'

6. Enter stocktake results

7. Print the Stocktake Comparison Report and check counts.

Repeat steps 6 and 7 until stock counts are correct.

8. Apply stocktake results
N.B. Ensure you select the F2 options key, then 'Dissec' and then
enter ***SA as the dissection to use.

9. Print a Stock Valuation report.

10. Continue with regular month-end procedures.




                                                               Prepared by Daniele Saunders & Partners, Confidential
                                                                                                            Page 11
                                                                     G:\Data Storage\Processing Checklists\Nexus.xls
                                                          Company Name
                                                  Purchase Order Processing Checklist

Daily/Weekly Procedures
1. Enter Purchase Order. Purchase Order can be printed directly by entering "D" when saving.
2. Print Purchase Order.
3. Receipt goods with or without invoice.
4. Apply invoices to receipts as necessary.
5. Check Daily procedures in Inventory and Accounts Payable Checklists.




Monthly Procedures
                                                  Jul    Aug    Sep   Oct   Nov    Dec     Jan    Feb    Mar    Apr    May     Jun

1. Complete daily activities
   (1-5).

2. Print Current Order Report

3. Print any other reports.

4. Purge Completed Orders as Required.




Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year.
3. Take a backup (yearly disks).
4. Run End of Year.




                                                                               Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                            Page 12
                                                                                     G:\Data Storage\Processing Checklists\Nexus.xls
                                                           Company Name
                                                    Sales Order Processing Checklist

Daily/Weekly Procedures
1. Enter Sales Order. Picking Slips can be printed directly by entering "P" when saving.
2. Check the Back Order Preview for conflicting releases.
3. Release Back Orders. Either via Backorder Release or via Order Maintenance.
6. Print Picking Slips, if required.
7. Release Sales Orders (this creates an invoice).
8. Goto the Stock Module, Processing Reports, Invoice Print and Update
9. Check Daily procedures in Inventory and Accounts Receivable Checklists.




Monthly Procedures
                                                  Jul    Aug    Sep    Oct    Nov     Dec    Jan    Feb    Mar    Apr    May     Jun

1. Complete daily activities
   (1-9).

2. Print Stock/Sales Order Status Report

3. Print Monthly Invoicing Summary

4. Print Back Order Report

5. Print any other reports.




Year End Procedures
1. Complete daily procedures for last day of year.
2. Complete the monthly procedures for the last period of the year.
3. Take a backup (yearly disks).
4. Run End of Year.




                                                                                 Prepared by Daniele Saunders & Partners, Confidential
                                                                                                                              Page 13
                                                                                       G:\Data Storage\Processing Checklists\Nexus.xls

								
To top