What is Imported from R.O. Writer

The following table describes what accounts are imported from R.O. Writer into QuickBooks.
Account Name	Account Type
Checking Account	Bank
The name of this account can be changed to their bank name or an account number. Deposits are posted to this account. Any money received in cash, checks or payment types in which the auto deposit box is checked are posted.
Accounts Receivable	Other Current Asset
Total AR charges and Total AR payments are posted to this account. No customer names or details are posted. If the account name in QuickBooks is not type, Other Current Asset, R.O. Writer will not be able to post to it.
Inventory	Other Current Asset
The total cost of parts sold on tickets (both stock and non-stock) reduces this account. The offsetting transaction to this is an increase to Parts Costs account which is cost of goods sold. When parts are purchased (both stock and non-stock) and an AP invoice is posted to inventory, that total increases this account. If AP invoices are not posted to inventory when the parts are purchased, this account can go negative.
Sales Tax Payable	Other Current Liability
Total Sales tax collected is posted to this account. If the account name in QuickBooks is not type, Other Current Liability, R.O. Writer will not be able to post to it.
Customer's Advance Payments	Other Current Liability
When an advanced payment is posted, it gets posted as an increase to this account. When the repair order is finalized, it gets posted as a decrease to this account. Any balance to this account is advanced payments received on repair orders that have not been finalized; therefore, no sales from this repair orders have been posted yet.
Accounts Payable	Other Current Liability
Nothing generally gets posted to this account but AP charge invoices get posted to the supplier accounts as sub accounts underneath this account when the Accounts Payable Parent Account option is selected in Configuration in the Accounting Interface module. If the account name in QuickBooks is not type, Other Current Liability, errors will happen on import.
Labor Sales - Non-Taxable	Income
Total non-taxable labor sales get posted to this account.
Labor Sales - Taxable	Income
Total taxable labor sales get posted to this account.
Sublet Sales - Non-Taxable	Income
Total non-taxable sublet sales get posted to this account.
Sublet Sales - Taxable	Income
Total taxable sublet sales get posted to this account.
Parts Sales - Non-Taxable	Income
Total non-taxable parts sales get posted to this account.
Parts Sales - Taxable	Income
Total taxable parts sales get posted to this account.
Core Charges - Non-Taxable	Income
Total non-taxable core charges get posted to this account.
Core Charges - Taxable	Income
Total taxable core charges get posted to this account.
Shop Supplies Sales	Income
Total Shop supplies get posted to this account.
Credit Card Fees	Income
When a fee is set up to charge customers for using a credit card in configuration, that total gets posted here. This is not widely used and there is a question on the legality of this fee in some states.
Finance Charges	Income
When finance charges are paid, they get posted as an increase to this account. Finance charges do not get posted to QuickBooks until they are paid which allows the customer to delete them if they wish without throwing anything off balance.
Labor Discounts - Non-Taxable	Expense
Total non-taxable labor discounts get posted to this account.
Labor Discounts - Taxable	Expense
Total taxable labor discounts get posted to this account.
Sublet Discounts - Non-Taxable	Expense
Total non-taxable sublet discounts get posted to this account.
Sublet Discounts - Taxable	Expense
Total taxable sublet discounts get posted to this account.
Parts Discounts - Non-Taxable	Expense
Total non-taxable parts discounts get posted to this account.
Parts Discounts - Taxable	Expense
Total taxable parts discounts get posted to this account.
Parts Costs	Cost of Goods Sold
Total Cost of Parts sold is an increase to this account. The offsetting transaction to this is a decrease to the Inventory account.
Credit Card Processing Fees	Expense
Under payment types edit , you can enter a percentage. This is the rate the credit card company charges the shop to process the credit card. During the reconcile and the creation of the import file, it calculates a percentage of the total amount for that credit card and is posted as in increase to this account.
Bad Debts	Expense
This account is currently unused.
Cash Drawer Adjustments	Expense
During the reconcile, the following window appears. It starts with the beginning Cash Drawer Balance, adds cash received from customers, subtracts cash paid out to vendors (AP Petty Cash invoices) and calculates how much should be in the cash drawer presently. If they count the cash and find it off, they can enter the actual amount and it calculates the amount over or under. This amount gets posted to this account and will increase or decrease the deposit amount to repopulate the cash drawer based on the Amount to leave in Petty Cash (cash drawer).
Fleet Discount	Expense
When a fleet account is set to receive a discount on what they owe and this gets credited to their account in Accounts Receivable, it gets posted as an increase to this account.
MasterCard/Visa Discover American Express Any other pay types	Other Current Asset
When payment types are set up, there is a box for auto deposit. When this box is checked, the total amount received on that payment type will get posted as an increase and then a decrease to this account balancing out to 0.00 and then the total gets posted as an increase to the Checking account. This is necessary to make the whole transaction balance and provide for that box not being checked. When that box is not checked, the total for that payment type simply gets posted as an increase to that account and never gets posted to the Checking account.
Tire Fee Battery Fee Hazardous Fee FET Freight Other Parts Fees	Other Current Liability
Fees added to parts are posted as an increase to this account. Taxable fees should be included on an income report in QuickBooks. Non-taxable fees are generally remitted to the state.
NAPA O'Reilly Any Other Suppliers	Other Current Liability
How supplier accounts appear in QuickBooks depends on the Accounts Payable Parent Account is set up in the Cash Drawer/Accounting Configuration setting. The account name entered in the Accounts Payable Parent Account field is the account name the suppliers are sub-accounts under. If this field is left blank, they will be separate accounts. The advantage to having them as sub-accounts of the Accounts Payable account is in QuickBooks they can collapse all sub-accounts to see a total owed in Accounts Payable or expand all sub-accounts to see what is owed to each supplier on the chart of accounts. Each AP "charged" invoice gets posted as in increase to the appropriate supplier account. After the charged invoice(s) are paid, they get posted as a decrease to the appropriate supplier account.
Core Returns Rent Uniform Cleaning Freight Other Expense Accounts	Expense
These accounts are added under General Accounts Expense Accounts. These accounts are used when posting AP invoices that are not purchased parts such as credit invoices, rent, uniform cleaning, freight, etc. The total amount of each invoice gets posted to the appropriate account as an increase.
Visa4455 Discover1987 Other Shop Credit Cards	Other Current Liability
These accounts are added under General Accounts Shop Credit Card Accounts. These accounts are the shops own credit cards that they pay their vendors with. When posting AP invoices or paying AP invoices by credit card, they use these pay types. It is suggested to add the last four digits of the card number to the account name so it does not match the payment types customers pay with as they are different types of accounts. The total amount posted will post as an increase to the appropriate credit card account.
R.O. Writer Sales	Other Asset
Everything except the credit card deposits and the Accounts Payable Invoices are posted to QuickBooks as one big general journal entry where the credits equal the debits. The transactions are held in this account. If you view this account in QuickBooks, you will see a general journal entry for each day you imported with a 0.00 balance. If you click on the split to see the detail of the transaction, you may see something similar to the below window. On the left are debits and the right are credits. Depending on the type of account as mentioned earlier in this document, debits and credits can be increases or decreases. All general journal entries must balance i.e., debits=credits. In the above example: A debit to the Checking account (Asset) is the deposit (Increase). A debit to the Accounts Receivable account (Asset) account is a charge (Increase). A debit to the Parts Costs account (Cost of Goods Sold) account is cost of parts sold (Increase). A credit to the Accounts Receivable account (Asset) account is a payment (Decrease). A credit to the Finance Charges account (Income) account is a payment toward a finance charge (Increase). A credit to the Sales Tax account (Liability) is sales tax collected (Increase). A credit to the Shop Supplies Sales account (Income) is shop supplies collected (Increase). A credit to the Advance Payments account (Liability) is Advanced payments received (Increase). A credit to the Taxable Parts Sales account (Income) is Taxable Parts Sales (Increase). A credit to the Taxable Fee1 account (Liability) is fees collected from parts (Increase). A credit to the Inventory account (Asset) is cost of parts sold (Decrease). Notice the amount charged to Accounts Receivable was $168.59. In this case, it was one repair order which only part(s) were sold. If you add up the following credits, sales tax, shop supplies, taxable parts sales, and taxable fee 1, it all equals the total charged to Accounts Receivable. Notice the amount deposited to the Checking account was $1,143.00. If you add up the Accounts Receivable payments, finance charges paid, and advance payments made on a ticket not yet closed, they all equal the total deposit (money collected). See Troubleshooting for information on common errors and other information.

Company Information	Support	Sales
Constellation R.O. Writer Inc. 11350 McCormick Rd. Plaza 3, Suite 200 Hunt Valley, MD 21031 www.rowriter.com	Phone: (800) 881-5859 https://support.rowriter.com	Sales: (888) 928-9769 Business: (561) 904-7300
R.O. Writer 2.3 The "R.O. Writer" name and logo are properties and registered trademarks of Constellation R.O. Writer Inc. Copyright © 2021 Constellation R.O. Writer Inc. All Rights Reserved. Any reproduction, redistribution, and/or other use of the information, images, graphics, content, and material, in whole or in part, contained herein without the express written permission of an authorized representative of Constellation R.O. Writer Inc. is prohibited. All other trademarks are the property of their respective owners.