Please enable JavaScript.

Coggle requires JavaScript to display documents.

SAP Accounts (Confirm Balance (J18950 Lotto (W/P: copy Lotto commission…

- - - - W/P: snip rebates and dividends summary
        from "W drive-admin doc-RPS issue" folder to W/P;
        manually enter into to W/P calculation sheet
        to confirm the balance.
    - - Snip balance from Foodnorth
        to W/P; confirm the balance.
        
        Recoded GL87300 balance
        to member savings if needed FB50;
        GL87300 balance should be Nil.
    - - Rebate paid into
        MS01 GL67001
        and TC GL62300.
        
        W/P: to confirm the balance, find rebates information from GL67001 and 62300 FAGLB03; manually enter into
        to W/P calculation sheet to confirm the balance.
  - - - W/P: enter Net Sales Total excl.GST from INCA Report;
        enter Department 11 sales KE5Z;
        enter Cafe Loyalty GL32150 balance FAGLB03.
        
        Occasionally, some stores have wholesale portions not included in INCA report. To find this, use KE5Z and sub-totaled by type, and enter the subtotal value under type "DR" into W/P. An example can be found in 5605 MMLP Mediterranean Reaward Queenstown Mar 2017 YE Accounts.
        
        If store has cafe loyalty program but GL32150 is nil. This means the store did not code free coffee cost to the correct account each month.
        To extract "Free Cafe Loyalty" value:
        Go to Portal-Reports-Retail Sales-Monthly Article Sales & GP Report. Then dag article 3259847 above Article headline on the left panel to see total free coffee giveaway each month.
        
        On the portal:
        1.remove "Department" and "Sub Department" from the left panel; 2. dag " " from the right panel to above the Article on the left panel; 3. Journal this value from (CR) GL10720 department 17 to (DR) GL32150 department 99 FB50 for each month. #
      - For Pak n Save Store: enter Packaging Net Sales to W/P.
        
        To extract "Packaging Net Sales" value:
        Go to Portal-Reports-Retail Sales-Article Sales & GP Report
        
        On the portal:
        1.remove "Department" and "Sub Department" from the left panel; 2. dag " " from the right panel to above the Article on the left panel; 3. the "Net Sales" figure should match GL18900.
  - - - W/P: snip and enter Lotto Float figure
        from questionnaire to W/P;
        enter Closing Cash on Hand
        from INCA Report to W/P.
        
        Journal Lotto Float difference
        to GL18950 (CC019) FB50 if needed;
        Confirm the balance on W/P.
  - - - Enter journals to adjust Petty Cash difference
        to relevant expense accounts
        or write off the balance to GL10720 FB50;
        
        Confirm the balance on W/P and SAP.
  - - - Documentations should be available
        at Accountancy Services Department.
        Attached a copy to W/P and confirm the balance.
    - - W/P: snip SAP balance to W/P FAGLP03 ;
        list ledger/invoice information on W/P.
    - - Documentations should be
        available at Accountancy Services Department
        from W drive: client's folder saved as PayGlobal (PGGL).
        
        W/P: Attached a copy to W/P and enter the total wages value to W/P to confirm the balance.
      - List Holiday Pay, Month End Allocation GL49000,
        Tasting & Sampling GL18750 information on the W/P FAGLB03 ;
        (Tips: use Filter function [e.g. sort by "Assignment"] to exclude "PG" (post from PGGL) to extract any manual adjustment value.)
        
        W/P: list SAP information in Holiday Pay,
        Month End Allocation, Tasting & Sampling on the W/P..
  - - - Confirm the balance; or investigate further
        and enter correct journal to fix it FB50
  - - - W/P: snip rebates and dividends summary
        from "W drive-admin doc-RPS issue" folder to W/P;
        manually enter into to W/P calculation sheet
        to confirm the balance.
    - - W/P: list bank interest information
        from SAP FAGLB03 to the W/P.
        Enter journals to gross up the interest with RWT FB50
        i.e. (CR) GL17200; (DR) GL98110.
      - W/P: list member saving interest
        information from SAP FAGLB03 to the W/P.
  - - - W/P: sum up GST input and output for
        Lotto commission; enter
        (negative for GST output and positive for GST input) into W/P.
  - - - W/P: enter shareholder names;
        snip GL84100-499 SAP balance
        to W/P S_ALR_87012277 ;
        enter journals FB50 to roll over to
        GL841/2/3/400 if needed.
    - - W/P: snip SAP balance to W/P FAGLB03 ;
        enter recoding journal FB50 if needed.
  - - - W/P: list all accruals on W/P with
        GST portion FBL3N
  - - - W/P: list all accruals on W/P with
        GST portion FBL3N
  - - - W/P: snip GL66100-499 SAP balance
        to W/P S_ALR_87012277 ;
        
        Confirm no open items on W/P FBL3N;
        To clear open items F-03 if needed.
- - - - Check the consistency compared to previous period
        
        Check if dividends, RP shares and rebates (produce, marketing, IT) declared on RPS statement
        
        Check if dividend transaction has been entered in SAP in GL18110 Div Received and GL18130 Imputation Credit FAGLB03
        (Please note this is for May accounts only, because Rebates paid in Jun. e.g.8069 NW Wakatipu) #
        
        Accrue Dividends Received and Rebates others (without GST) to GL71500 FB50
    - - Check the consistency compared to previous period (should have 12 months (YE) or 6 months (interim) rebates in this accounts) FAGLB03
        
        Accrue (without GST) the missing months rebates to GL71500 FB50
    - - Lotto Weekly cut-off on Tuesday, so we accrue any transactions do not relate to the period prior to the last Tuesday of the month.
        
        Check Lotto cash banked (received) after the last Tue within the period FAGLB03 and enter journal to defer this payment to account as income for the next perioid (DR 18950, CR 71500) FB50
    - - Check the consistency compared to previous period (should have 12 months (YE) or 6 months (interim) rebates in this accounts) FAGLB03
        
        Accrue the missing months rebates to GL71500 FB50
    - - Check if any other income should be accrued from future period FAGLB03
        Tips: normally 17730, 19200 should be accrued
        
        Accrue these transactions to GL71500 FB50
  - - - Check 2017 GLs FAGLB03
        To accrue FB50
        Accrued GST portion to GL92305
      - K40600: daily interest
        should be accrued.
        
        e.g. Apr interest $300 paid on 10th / 30 days = $10 per day;
        $10 per day x 21 days in March = $210 to be accrued. FB50
    - - Check 2017 GLs FAGLB03
        To accrue FB50
        Accrued GST portion to GL92305
    - - Check GL92810 opening balance FAGLB03 to make sure it agrees to the W/P.
        
        W/P G92810:
        Snip PayGlobal annual leave report from questionnaire;
        Sum up annual leave and leave credits
        
        Enter accrual journal FB50
    - - After balance confirmed on K31000 & K40500 W/P, check if you need to enter journals for prepayments; enter journals FB50 Cr 31000/40500, and Dr 71400. #
    - - Accrue last 1-2 weeks FS statements payments made in the following month.
        
        Snip FS statements to W/P from OnBase e.g.
        
        Accrue to GL91900 from GL66133 FB50 e.g.
        Please reverse this transaction immediately on the first date of next fiscal period FB08 so GL66133 will not be overstated.
- - - - Departments 4, 6, 9, 10, 11, 13, 14, 15,19, 21, 24, 25, 99 should be nil.
        
        Bulk food/dept 12 might find packaging cost under COGS GL20002/3
        
        Compare to the last six months accounts and check the consistency.
    - - Departments 2, 4, 5, 6, 9, 10, 11, 12, 14, 15,19, 21, 24, 25, 99 should be nil.
        
        Recode any consumables to COGS GL20003 FB50 e.g. wrapping paper under Flower/dept 14.
        
        Some consumables might relate to Stationery GL43000 (e.g. sellotape), Cleaning GL37200 (e.g.wippers) or COGS GL20003 (e.g. flower).
        
        Compare to the last six months accounts and check the consistency.
    - - Departments 10, 11, 18 (Fuel dept only applies to PNS), 20 (Loyalty dept only applies to PNS), 22(do not exist) should be nil.
        
        Departments 25, 26, 99 should only contains wages.
    - - Departments 1, 2 (polybin), 5 may incur freight costs.
        
        Check the nature of the cost by using FAGLB03 and KSB1 to analyse them.
- - - - Investigation required to clear open
        items MIR6, FBL1N, FBL5N, ME23N.
        
        Further investigation by Dunedin office/Elaine's team
        might be required.
- - - - Enter journals to GL98500 as Current Liability FB50
  - - - Confirm the balance; enter
        adjustment journals FB50 if needed.
  - - - W/P: snip a copy of invoice and installment schedule on the W/P; list the administration and interest costs on the W/P.
        
        Journal total net expense (e.g. insurance cost) to (CR)GL88260 as liability and (DR)GL40500 to account for expense incurred. Note:when using FB50 , GST code "P2" should apply to GL40500.
        
        If establishment/admin fees incurred, then journal this amount to (CR)GL88260 as liability and (DR)GL88270 or GL36500(from year 2017) to account for admin expense incurred. Note:when using FB50 , GST code "P2" should apply to account for GST.
        
        Proforma journal example:
        
        To see an example, go to 8009 WAIP New World Waimate, Mar 2017 FAGLB03
  - - - The income realisation schedule and invoices should be provided on the Workpaper. Sample can be found in NW Mosgel 8031 on YE 2017 workpapers.
- - - - W/P: copy ICA information from the
        previous W/P to the current W/P;
        
        Request and snip a copy of ICA summary and IRD tax position up to date, then enter tax journals FB50 and confirm the balance.
        
        To see an example, go to 8056 BMLP New World Bishopdale, Sep 2017 FAGLB03
  - - - W/P: snip GL92300-92399 SAP
        balance S_ALR_87012277 to W/P;
        list details on W/P and confirm the balance.
        
        W/P: list all GST accruals and adjustments details on W/P,
        then confirm the final balance. Tips: use ZFR012
        to find adjustments posted in SAP for specific period.
- - - - Compare
        GL18900 and Portal
        
        Portal-Reports-Retail Sales-Monthly Article Sales & GP
        
        *Some Store have this article under dept 06 in Toy & Game section, for example South City NW.
        
        On the portal:
        1.remove "Department" and "Sub Department" from the left panel; 2. dag "KIddie Carts Hire" from the right panel to above the Article on the left panel; 3. the total value of "Net Sales" should match to GL18900. Otherwise, manual journals are required to adjust against GL20003 under dept 21.
        
        Recode from GL10720
        to 18900 if needed.
  - - - 50% non-ded: Enter information to W/P calculation sheet, then recode to GL59040(GST incl), FB50 e.g. Dr 59040(PE), Cr 44510(P2).
      - 100% non-ded: Enter/snip information to W/P, then recode to drawings(GST incl), FB50 e.g.Dr 84151(PE), Cr 44510(P2).
- - - - Check if DM balance agreed to
        SAPS_ALR_87012284
- - - - W/P: snip and enter inventory figures
        from questionnaire to W/P.
        
        W/P: to confirm GL74100 balance,
        snip portal report at "Reports-Finance-
        Inventory Management-Retail Daily Inventory on Hand" to W/P.
        
        Confirm all balances are matched,
        enter stock resetting journals if necessary as per example below:
        
        An alternative way to reset the stock is to enter through the portal.
        (DO NOT USE THIS METHOD ANYMORE, ONLY APPLY TO THE STORES)
        
        Make sure you change the company code in SAP under "System-Own Data-User Profile", enter the correct company code under Parameters as per below:
        
        Go to Portal at "Manage Inventory-Adjustment Stock-Reset Value Only Stock" enter the data into the required fields as per below:
  - - - SAP: Reverse previous journal and
        enter journal to credit GL42340
        to restate current closing balance.
- - - - SAP: use AS01 to create assets, record asset #s to W/P and use ABZON to create values for assets and post to GL95951.
        
        Enter journals FB50 to clear GL95951 against GL52210 (Sold Asset Clearing), 62020 (Assets), 62030( FS Plant Accounts); confirm these asset clearing accounts are nil at the end of the period.
  - - - Confirm the balance: snip the SAP balance from S_ALR_87012004 and the balance from portal report at "Reports-Finance-Store Owner-Fixed Asset and Depreciation Schedule" to W/P. Make sure these balances are matched.
        (Portal report only refreshs over night)