Accounting GL Over and Short

OverShort GL code

This allows you to create Over and Short GLs and link them to the desired store codes to be exported using our accounting extensions

 

To see a video on GL code set up, click here>>

Quick Steps

• Set up GL accounts for Over and Short.

• Assign GL accounts to stores in Tools | Options | Accounting | OverShort GL code.

• Complete a cash count.

• Export using desired extensions, such as Sage.

• Review results in Excel.

Note:  This will only work for data moving forward.  Past data will not export the over and short. 

To set up the GL account for Over and Short

1. In Tools | Options |Accounting | Store Accounting Code.

2. Click Add. Two drop-down fields display.

3. Select Over Short from the GL Account list.

4. Select the store from the Store Code drop-down list.

To assign the GL accounts to stores

1. In Tools | Options | Accounting | OverShort GL code. The Manage Over Short GL Codes display.

2. Select the GL account to use and click Edit. Two drop-down fields display with the top field displaying the store.

3. From the GL Account drop-down field, select the GL Account [Over Short].

4. Click Save.

5. Click Close when done.

Complete a cash count {starts at 2:53 in the movie - Insert link

1. Go to the Sales screen.

2. Find the product in the Product Search field. For example: Glove-Callaway Tour Authentic MLH WHT

3. Finalize Sale.

4. Select Cash (or any method) for payment.

5. Open Cash Count. [From the menu bar, go to Sale | Cash Count.] The Cash Count screen displays.

6. Select the Shift Change button.  A prompt displays. Click Yes for it.

7. In the Search (date/terminal/shift) drop-down field, select the shift to search.

8. Look at the Over/Short field near the bottom of the screen.

9. If it contains a figure or is red, you can report on this amount.

10. Click Save and Close.

11. Review results in Excel.

12. Export using desired extensions (like Sage). To see how, jump here for Sage or jump here for QuickBooks>>