This WIKI will go over the steps on transitioning your Accounts Receivable in three different methods.
Explain three methods for transitioning your A/Rs to Control. Choose the method you want to use. Your choices are:
Method 1
Method 2a
Method 2b or
Methods 2a and 2b.
Activate the Transition Products in Control.
Create a transition tax class, only to be used for entering your starting A/Rs. Name it “Exempt Tax Class only for Transitional A/Rs.”
Show you the detailed steps to follow for each method.
Method 1 Show you how to set your starting A/Rs up in Control using the Bulk A/R method;
Method 2a Show you how to set your starting A/Rs up in Control using the Individual Net A/R method; and,
Method 2b Show you how to set your starting A/Rs up in Control using the Original A/R method.
See all your A/Rs and compare your A/Rs to the old system. Verify they are correct.
Deactivate the transition Products in Control.
Deactivate the transition Tax Class in Control.
There are two methods for transitioning you’re A/Rs to Control
Method 1 - Bulk A/R Method (Maintain Dual Systems): Create a single bulk starting A/R in Control so your balances in the two systems match, but track old A/Rs through your old system.
How it works: Total up the A/Rs in your old accounting system. Create a single A/R in Control for this total amount with yourself as the Customer. As you receive payments on those old A/Rs in the future, you’ll process those in both Control and in the old system. Any new orders placed and payments made by those customers on new orders would only be entered in Control.
The benefit of this method: This method is easier for companies that have a lot of A/Rs at the time they are transitioning to Control. This lets them avoid the up-front work of recreating all those individual A/Rs.
Method 2a - Individual Net A/R Method (Full Switch): Create an A/R in Control for the net amount each of your outstanding A/Rs and use Control solely going forward.
How it works: Create each A/R in Control so the Control A/Rs match your old accounting system’s A/Rs. As you receive payments on those old A/Rs, you’ll process those only in Control. Any new orders placed and payment made by those customers would only be in Control.
The benefit of this method: This method centralizes the management of A/Rs going forward and avoids a number of challenges from running dual systems. It is especially good for companies that have a small number of A/Rs at the time they are transitioning to Control.
Method 2b - Original A/R Method (Full Switch): The same as Method 2a except for the following:
The A/Rs you create in Control are for the original amount; and,
You enter the payments you’ve already received against those A/Rs.
Note: This is a good time to review your A/Rs to see if they need to be “cleaned up.” Are there old A/Rs that you know you’re extremely unlikely to get paid on? Is it time to write them off? You may want to do the cleanup work in your old system, so you start Control off as clean as possible.
Activate the Transition Products in Control. (just the one(s) they plan to use based on their choice above
Click Setup.
Click Pricing Setup.
Click Adjust Product Information Setup.
Check the Show Inactive check box (in the lower left corner of the screen).
Click Edit.
Click on the Category called Transition Products. Note: This step uses special products in Control. If you don’t see these products in your system, call your point person in the Startup Department.
Check the box(es) in front of the A/R Transition product(s) that corresponds to the method(s) you’ve decided to use.
Click Save.
Create a transition tax class, only to be used for entering your starting A/Rs. Name it “Exempt Tax Class only for Transitional A/Rs.”
To create a tax class for this, follow these steps:
Click Setup.
Click Accounting Setup.
Click Tax Classes.
In the center column, click on a tax class in the center column to clone.
Click the Clone button on the right toolbar.
Change the name of the new tax class that you just created to “Exempt Tax Class only for Transitional A/Rs.”
Make sure Tax Exempt is selected. If not, click on the circle in front of it so it then has a dot in it that looks like this:
Note: This is only to be used when you are transitioning you’re A/Rs to Control. Using this tax class for your transition receivables assumes that you have already paid any required taxes when this A/R was in your old system. If this is not the case, DO NOT use this tax class. Instead call your contact in the Startup Department to discuss the best way to proceed.
Show you the detailed steps to follow for each method.
Method 1: Set up your starting A/Rs in Control using the Bulk A/R Method.
First, total up the A/Rs in your old accounting system.
Open Control. We recommend you use your own company as the Customer to put the Bulk A/R under. You may need to create the company record. If so, do this to create a company in Control for your company:
Click New.
Click New Company.
Enter your Company Name, Address, Phone Number, and Contacts.
Click Save.
Now let’s create a place-holder order to put the Bulk A/R under.
Click New.
Click New Order.
Click on the “+” sign next to the Transition Products folder (product category).
Double click the Transition A/R Method 1 product.
Type in the following information:
Item Name: Enter “Receivables from Old System”.
Total amount of all A/Rs: Enter the total A/R balance from the old system.
Description: Add any notes you like.
Click OK.
Choose your own Company to attach this order to.
Enter the Description “Receivables from Old System”.
Click on the Totals tab.
Click on the button to the left of the word Taxes. This will open the Tax Class Selection window.
Check the box that says Tax Exempt and click OK to close that window.
Click Save.
Click Save as Order.
Once it has saved, we need to make it a sale before the balance owed will show up in A/Rs. Click the down-arrow next to the Status button.
Click Sale.
Click the first choices under *Sale called leave as is. You’ll notice the top right of the screen now says Sale.
When the dialog box pops-up confirming that you want to do this, click Yes.
You’ve finished the setting up your starting bulk A/R in Control.
Method 2a: Set up your starting A/Rs in Control using the Individual Net A/R Method.
First, print out a list of the A/Rs from your old accounting system. Make sure you have a breakdown of the pre-tax amount, taxes, and total amount, payments made, and balance outstanding on the report.
Open Control.
Now let’s create an order to put the first individual A/R under. (These instructions assume that the customers that have A/Rs on your list have been imported earlier in the set up process. If not, then follow steps B2a) to B2d) above to create those companies in Control.)
Click New.
Click New Order.
Click on the “+” sign next to the Transition Products folder (product category).
Double click the Transition A/R Method 2a & 2b product.
Type in the following information:
o Example 1: Customer A ordered a $950 sign from you, which you have delivered to them. They gave you a $200 deposit, so the current A/R for this order is $750. Enter $750.
o Example 2: Customer B ordered a $1,400 sign from you, and has already made an $800 payment. The current A/R for this order is $600. Enter $600.
o The order number from your old accounting system;
o If there have been prior amounts or deposits paid on this order; and,
o Any other notes you like.
Click OK.
Choose the Company to attach this order to. If the company doesn't exist, you can create it at this time:
i. Click on the **Company** tab.
ii. Click the **New Company** button. This will open a new company entry screen in another window.
iii. Enter the company information, including the default tax information for the company as well as primary and billing contacts.
iv. Click **Save** on the toolbar. It will save the company, close the window, and fill in the information for that order.
Enter the Order Description.
Click on the Totals tab.
Click on the button to the right of the word Taxes. This will open the Tax Class Selection window.
Make sure the Tax Class box that says Exempt Tax Class only for Transitional A/Rs. If not, change it to Exempt Tax Class only for Transitional A/Rs.
Click OK to close that window.
Click Save.
Click Save as Order.
Once it has saved, we need to make it a sale before the balance owed will show up in A/Rs. Click the down-arrow next to the Status button.
Click Sale.
Click the first choice under Sale called leave as is. You’ll notice the top right of the screen now says Sale.
Repeat the above step for Each A/R.
You’ve finished the setting up your starting individual A/Rs in Control.
Method 2b: Set up your starting A/Rs in Control using the Original A/R Method.
First, print out a list of the A/Rs from your old accounting system. Make sure you have a breakdown of the pre-tax amount, taxes, and total amount, payments made, and balance outstanding on the report.
Open Control.
Now let’s create an order to put the first individual A/R under.
Click New.
Click New Order.
Click on the “+” sign next to the Transition Products folder (product category).
Double click the Transition A/R Method 2a & 2b product.
Type in the following information:
o Example 1: Customer A ordered a $950 sign from you, which you have delivered to them. They gave you a $200 deposit, so the current amount entered is $950. (assume these are all pretax numbers)
o The order number from your old accounting system;
o If there have been prior amounts or deposits paid on this order; and,
o Any other notes you like.
Click OK.
Choose the Company to attach this order to. If the company doesn't exist, you can create it at this time:
Click on the Company tab.
Click the New Company button. This will open a new company entry screen in another window.
Enter the company information, including the default tax information for the company as well as primary and billing contacts.
Click Save on the toolbar on the right. It will save the company, close the window, and fill in the information for that order.
Enter the order Description.
Click on the Totals tab.
Click on the button to the right of the word Taxes. This will open the Tax Class Selection window.
Make sure the Tax Class box that says Exempt Tax Class only for Transitional A/Rs. If not, change it to Exempt Tax Class only for Transitional A/Rs.
Click OK to close that window.
Click Save.
Click Save as Order.
When the popup appears asking if you’d like to post a deposit, click No.
Now we need to make it a sale before the balance owed will show up in A/Rs. On the tool bar on the right, click the down-arrow next to the Status button.
Click Sale, then click the first choices under Sale called leave as is. You’ll notice the top right of the screen now says Sale.
Now let’s process the deposits and/or payments received on this order. Click on the Payments tab.
Click Edit.
Click the Payments Account you want to use for the payment. Note: If you have purchased the online credit card module, make sure you do NOT reprocess those cards here. Consult with Cyrious support about creating an alternate, temporary, payment method to post these charges against without running the payment.
In the Deposits/Payments field, enter the total of all the deposits and payments received for this order as of the transition date.
Click Save.
A pop-up window will ask you for a reason for the information you’re saving. Type in something like: “Payment for transition (A/R).”
Control will give you a message confirming that the payment has been posted. Click OK.
Repeat the above step for each A/R that you want to record the original sale price and payments for.
You’ve finished the setting up your starting individual A/Rs in Control.
To verify your A/R totals:
Click on Reports.
Click on Customers and Receivables.
Click on A/R Reports.
Click on A/R Summary report or the A/R Detail Report depending on the detail you want.
When the pop-up window appears, click Preview.
Compare the total balance due to make sure it matches your old system. Compare the balance due for each A/R.
Deactivate the transition Products in Control.
Now that you’ve finished transitioning you’re A/Rs, you need to deactivate the Transition Product(s). To do this, follow these steps:
Click Setup.
Click Pricing Setup.
Click Adjust Product Information Setup.
Click Edit.
Click on the Category called Transition Products.
UNCHECK the box(es) in front of the Transition product(s) that you used.
Click Save.
Deactivate the transition Tax Class in Control.
Now that you’ve finished transitioning you’re A/Rs, you need to deactivate the Transition Tax Class. To do this, follow these steps:
Click Setup.
Click Accounting Setup.
Click Tax Classes in the left column.
Click on the transition tax class in the center column.
Click Edit.
UNCHECK the box to the right of the Tax Class Name.
Click Save.
Great job! You just finished the toughest part of the transition tasks. Now you’re ready for the next transition task.