CC Recon

Section 1 -

1. Remote into 192.168.10.211

2. Open up QuickBooks

   1. Open up the active company file under the Admin Login.

      1. As of 11/07/2023 it’s ‘Ticket Boat Inc 2023.qbw'

3. Open up the Find Function in the company.

   1. This can be done by hitting the keys 'CTRL + F'

4. Set up the function as below:

   1. Transaction Type - Credit Card

   2. Date - 12 months ago to today

5. Click the ‘Find’ button.

6. Click the ‘Export’ Button

   1. Select the ‘Create a comma separate values (.csv) file’.

   2. Click Export again and save the file to the .211 remote desktop as something you can remember.

Section 2 -

7. In .211, open up file explorer.

   1. Go to the ‘Live' Folder.

   2. File path: C:\Shares\Accounting\Quickbooks\Vlookup\Live

8. Select ‘CC Recon + Cancels' and hit the keys ‘CTRL + C’

   1. When selecting make sure you aren’t opening it.

9. Click on your local desktop outside the remote application and hit ‘CTRL + V’.

   1. You should have a copy of the CC Recon on your desktop.

10. Repeat steps 8-9 for the export created in section 1.

    1. You should have the CC Recon and your Export on your local desktop.

Section 3 -

11. On your local desktop, open both excel files.

12. Copy the entire ‘NUM’ Column from the export file and paste it to the entire ‘P' column on the 'PO Report’ tab on the CC Recon file.

    1. The ‘NUM’ column is usually column 'D'

    2. The ‘P' column in CC Recon is important due to the formula being used next. If not, in 'P’ column make adjustments.

13. Paste this formula into J1: =IF(IF(IFERROR(VLOOKUP(C2,P:P,1,FALSE),0)=0,0,1)+IF(IFERROR(VLOOKUP(G2,P:P,1,FALSE),0)=0,0,1)>0,1,0)

14. While J1 is selected, hit ‘CTRL + C’ then select J2 to the last filled line then hit ‘CTRL + V’ while the entire thing is selected.

    1. Easily select the require area by starting at the bottom and select up by holding ‘CTRL + Shift’ and use the up arrow key in column 'J'.

       1. You can easily get to the bottom of the last filled line by selecting the first cell in the ‘PO Date’ column and holding ‘CTRL’ and press the down arrow key until you reach the last filled line.

    2. The ‘Shift’ key is the hotkey to highlight.

    3. The ‘CTRL’ key is the hotkey to move mass amounts of line.

       1. To the next break in information.

15. Click on the ‘Formulas’ Tab at the top.

16. Click ‘Calculate Sheet’ on the right side of that tab.

    1. This will recalculate all formulas on the selected sheet.

17. Sort column ‘J' from ‘A-Z’/’Smallest to largest'.

    1. Allow this to sort before moving onto the next step.

18. Sort column ‘J' to only show the '1’s.

    1. Allow this to sort before moving onto the next step.

19. Delete ONLY the yellow cells.

    1. Column C-H and J

20. Resort column 'J' to show everything again.

21. Delete the information in column ‘J' and 'P’

22. Save the document.

23. Open the Inventory Discrepancies excel and go to the ‘Available POs’ tab.

24. Delete the information under columns A-F in the Inventory Discrepancies excel.

    1. Leave Row 1 alone.

25. Copy the information under columns C-H in the CC Recon file.

    1. Leave Row 1 alone.

26. Paste the information you just copied into Inventory Discrepancies columns A-F.

    1. Leave Row 1 alone.

27. Close the excel files.

28. Copy the CC Recon on your local desktop.

29. Paste the file into the CC Recon directory on .211.

    1. Click Copy + Replace.

       1. This puts the new updated CC Recon back into production.

-Done-