Accounts Receivable Updates & Tasks

A checklist to implement the Revamping of Sales Tax Reporting and additional longer-term Accounts Receivable maintenance projects on the Eagle System as discussed 14 October. Based on the sales tax quarterly close at the end of November 2015, all work on the set-up of accounts regarding the revamping of tax reporting must be completed before that date. Michael Cinelli has no problems with a gradual implementation of the accounts between now and the November 30th cut-off date.

Sales Tax Revamp Prerogatives: 

 1. Set Up New Tax Codes

2. Erase All Existing Tax Codes For Non-Exempt Customers / Jobs

Removed all T## jurisdictional tax codes on jobs and delivery accounts

3. Determine Legitimacy of Non-Taxable Status of following 41 Non-Job Accounts

>> If Legitimate - Code as Shown in Step # Below
>> If unwarranted (or set-up incorrectly) Change to Taxable = Y in MCR

 

*90304	CHILLY WILLY & COOL CARLS ICE	N
*90341	JOSEPH W. CURVINO	N
*90625	JOSEPH R. FORSTER	N
*90626	FLOORING 23 CORPORATION	N
*91102	K J TILE	N
*91121	KHCG CONST-EAST MANHATTAN	N
*91214	L & M RESTORATION & ROOFING	N
*91325	MEDIA RANCH	N
*91389	MARFI CONTRACTING CORPORATION	N
*91512	OLYMPIA FLOORING / GALAXY	N
*91613	PICCINI INDUSTRIES LIMITED	N
*91962	S & J SHEET METAL	N
11215	ALLSTATE INTERIOR & EXTERIOR	N
120126	LAKEVIEW GROUP ASSOCIATES	N
131600	MPR	N
140540	NRS-SPECIAL ACCOUNT	N
160116	A PALMIERI LANDSCAPING COMPANY	N
160117	A PALMIERI WEEKLY ACCOUNT	N
160507	PETER J. LANDI INCORPORATED	N
161811	TONY & PAT PROSPERO	N
181506	JOSEPH ROMA & SONS	N
190805	SHELDRAKE ENVIRONMENTAL CENTER	N
191019	S & J SHEET METAL	N
192045	STONE QUEST	N
200120	TATTI & ASSOCIATES	N
20516	BELLEVILLE LANDSCAPING	N
20522	BELLEVILLE LANDSCAPING	N
20528	BELLUX	N
211201	ULTIMATE SITE SERVICE	N
21201	BLONDIES TREEHOUSE	N
22104	MARIO BULFAMANTE & SONS	N
230102	WAVE HILL INCORPORATED	N
230112	WALL SYSTEMS SUPPLY	N
230529	WEST YONKERS DEVELOPMENT	N
231204	WLD ABEYANCE ACCOUNT	N
251501	YONKERS CONTRACTING	N
30502	C E R D / ELLIOT KRACKO	N
30826	CHILLY PREPAID	N
30827	WILLY CHILLY	N
40513	DERECKTOR SHIPYARD	N
40526	JOHN DEERE LANDSCAPES	N

4. Establish Groupings for Account Receivable Exempt Customers to Accurately Designate Tax Code Set-up:

 

 

 

 

 

 

 

 

 

 

 

5. Code ALL Legitimately Exempt Non-Job Customers in MCR Accordingly 

A. On Tab 1 / Main Screen of MCR:
i.Set to Taxable = N
ii. Set Tax Code by Group to:

• Charity Accounts = XOR
• Diplomatic = XDI
• Direct Pay Permit = XDP
•  Educational Institutions = XOR
•  Governmental Accounts = XOR
• .Medical Institutions = XOR
•  Religious Institutions = XOR
•  Re-Sellers / Wholesale Accounts = XRE   

6. Code ALL Legitimately Exempt Job Sub-Accounts in MCR Accordingly

A. On Tab 1 / Main Screen of MCR:

• Set to Taxable = Y 
• Set Tax Code to Job's Delivery Destination = ### (Numeric Zones From Chart in Step 1)

B. On Tab 6 / Misc. Screen of MCR:

• Tax Override Plan: T=Y 

7. Changes POS Constants & Codes On or Before November 30, 2015

A. Manually Change Tax Codes on Open / Uninvoiced POS Documents

• POS Orders / Special Orders
• POS Holding Layaways
• Unexpired POS Quotes & Bids

B. Change Options Configuration ID #104

• Stores 1 & 2 = 581
• Store 3 = 921

8. Tie Up Loose-Ends & Consider Implementing Other New Tax Tools

A. Confirm Inventory Non-Taxable Status for following items is correct / incorrect

Item Number	Item Description	Tax Status
.BC	LANDSCAPE DEPOT BANK CHARGE BACK	N
.RC	LANDSCAPE DEPOT: RETURNED CHECKS	N

B.  Confirm Inventory Custom Tax Codes are still requited - or how to set-them up

Item Number	Item Description	Tax Code
FILLUP100	PROPANE GAS REFILL 100# CYLINDER	PTW
FILLUP20	PROPANE GAS FILL-UP 20# CYLINDER	PTW
FILLUP30	PROPANE GAS FILL-UP 30# CYLINDER	PTW
FILLUP40	PROPANE GAS FILL-UP 40# CYLINDER	PTW
FILLUP60	PROPANE GAS FILL-UP 60# CYLINDER	PTW
PROPANE	PROPANE GAS REFILL PER GALLON(S)	PTW
NEWTANK	NEW 20# PROPANE TANK GAS & PURGE	PTW
PURGE	NEW PROPANE FIRST FILL AIR PURGE	PTW
OLDTANK	OLD 20# PROPANE TANK DISPOSE FEE	PTW
.GC	GIFT CERTIFICATE PER DOLLAR UNIT	WGC

C. Implement Resale Code Expiration With Options Configuration ID #9285?
Requires additional set up on Tab 6 / Misc. Screen of MCR:

D. Implement and Test Options Configuration ID #8631?

E. Test and Decide the Best Reporting Setting Options Configuration ID #8255
F. After Enabling Cash Customer Info Window Prompt for Generic * Exempt Customers - Now Find Out how to make Fields Required

G. Check Other Exemption Configurations
http://www.activant.com/EAGLECUSTOMERS/olh/index.htm#Reports/AR_Rept_Examples/rtx_report_sample.htm

Other Account Receivable File Maintenance: 

1. Delete Expired Jobs
2. Change Defunct Accounts to Job #s Under one Master Defunct Accounts Master Acct #
3. Change Bad Debt / Never Open Again Accounts to Job #s Under one Stiffs Master Acct #
4. Pick ONE of the current 2 employee sales accounts set-ups