Cash Management Report Reconciliation

Reconciling Cash Position And Liquidity Forecast Reports

> Cash Position:

Compare FF7A with the trial balance (FS10N or F.01), note that FF7A uses the exchange rate valid at the day you run the report while FS10n uses the exchange rate recorded when the GL entry was posted, so there will be some differences between FF7A and F.01

In case of unreasonable differences, run transaction FDFD and do a data correction for all GLs then check again


> Liquidity Forecast:

1. Compare FF7A with the customer/vendor aging report (FDI0/FKI0)

2. If there's a difference then compare FF7A with FBL1N/FBL5N (use the Due Date column not the Posting Date column)

3. If there's still unreasonable difference then run transaction FDFD and do a data correction for All Customers/Vendors


NOTES

1. TCODE TRTC includes all CM reports

2. CM tables start with FD*:

  • FDFIEP (CM: FI Line Items (OP of Deb/Cred for Drilldown))
  • FDSR2 (CMF Totals Records for customer/vendor Planning Groups)
  • FDSB2 (CMF Totals Records for GL)
  • and many others




7 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. Thanks a lot very much for the high quality and results-oriented help.Keep in blogging .Vendor Reconciliation | Inventory Verification

    ReplyDelete
  4. Amazing post. Keep it up. Much thanks to you such an incredible sum for sharing your beneficial blog.
    Duplicate Payment Audit
    AP Vendor Helpdesk
    Duplicate Invoice Audit

    ReplyDelete
  5. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Projects for CSE It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai


    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete
  6. Hi, I find reading this article a joy. It is extremely helpful and interesting and very much looking forward to reading more of your work.. Ottawa Chartered Professional Accountant

    ReplyDelete