sage 100, sage 100 support, sage 100 era, sage 100cloud, sage 100c, sage 100 manufacturing, sage 100 consultant, sage100, sage 100 classes, sage 100 training

Sage 100 2018.3: Job Costing Module Changes

With each annual Sage 100 software release, Sage introduces periodic updates for their Sage 100 2018 software, which include useful improvements and bug fixes to help your Sage 100 product run more efficiently. The most recent update, Sage 100 2018.3, includes many helpful changes to the Job Costing module.

 

What’s new in the Sage 100 2018 Job Costing Module?

  • Fix “(Tax Code)” is not numeric” in version 2018 Job Billing Data Entry for a Fixed Contract job
  • No longer receive “record (report Name) is missing from SY_ReportManagerMaster.M4T.” when using the Designer button to open any report on the Job Cost > Estimating menu.
  • Cost Code Maintenance is no longer truncating alphanumeric Cost Code numbers that include a special character.
  • Job Estimate Printing *SUB and *TOT calculation is now correct if the line is deleted and re-entered to a different line on the grid.
  • New Comments or changes to Comment are now retained in Job Maintenance.
  • Corrected issue with Time & Material transactions not summarizing by Job in Daily Transaction Purge Closed Jobs Dated on or Before
  • Users are now able to enter an Actual Percent Complete greater than 9% in Job Billing Data Entry.
  • User can able to proceed the Sales Tax Calculation with J/C Job Billing selected. There is no Error 88 AR_Salestaxcalculation_bus.pvc 119 displayed.
  • Fix Error: “A missing GL account was found in Job Type: xxx” in Job Billing after converting to version 2018 and “Post to G/L for Work in Process” is unchecked in Job Cost Options.
  • A/R Invoice with a job referenced is no longer adding $1 Sales Tax Billed to the invoice in Job Billing History – Version 2018.
  •  Calculated Overhead Allocation amounts from Job Posting Entry transactions are correct.
  • Error 26 is not occurring for the Job Transaction Detail History Report & Job Transaction Detail Report when selecting Save As for the reports.
  •  Job Billing Data Entry Fixed Bill Totals tab is now displays the Job-To-Date Cost instead of the Year-To-Date Cost.
  • Transaction Date is retained in Primary Grid when exiting Job Posting Entry.
  • Trans Date in Job Posting Entry is now defaults to Module Date not System Date.
  • Cost Code Detail Unit Price and Unit Cost amount can be entered after the decimal.
  • Job Billing Data Entry line Bill Amount is recalculate correctly when Bill Rate is changed for a Time & Material job in version 2018.
  • Fix Job Billing Register update to G/L does not relieve WIP when Post to G/L for WIP is selected in Job Cost Options.
  • Added validation in Cost Types to not allow special characters. Increased size of Valid Cost Type field to 36 characters.
  • PO Receipt Register and PO Return Register update hangs when there are multiple lines which include Job Cost detail.

 

sage 100 2018.3 job costing moduleAccounting Business Solutions by JCS is a leading Sage 100 consultant offering Sage 100 support, training, and data repair services to help fix the problems you may be having with the Job Costing Module in Sage 100 2018.  Our certified Sage 100 consultants have years of experience helping businesses just like yours maximize the efficiency of their Sage 100 ERP software. To get started with Sage 100 software, call us at 800-475-1047 or email us at solutions@jcscomputer.com. Your success is our goal!

The Sage 100 2018.3 download link can be found here.

sage 50 bank reconciliation

How to Run an Audit Trail Report in Sage 50

What is an Audit Trail Report in Sage 50?

The Audit Trail Report is a useful report which helps users locate and correct Sage 50 errors by offering them a detailed chronological listing of all changes made in their Sage 50 company file. This useful report shows the date and time of the modifications, as well as the user who made them. The Sage 50 Audit Trail offers unique customizable columns and can assist you in pinpointing Sage 50 data errors.

 

How do you run an Audit Trail Report in Sage 50?

To run an Audit Trail Report, follow these steps:

  1. Select Reports & Forms

Audit 1

 

2. Select Company, then select Reports

Audit 2

 

3. Select Audit Trail Report

4. When the report opens, it defaults to today’s activity.  Click Options (Gear icon) to select your specific date range.

Audit 3

 

Are you having trouble with your Sage 50 or Sage 50c software? The certified Sage consultants at Accounting Business Solutions by JCS offer Sage 50 training, support, and data repair. Our experienced Sage 50 experts can help get rid of your Sage 50 error  messages, including those which can be fixed with the Sage 50 Audit Trail Report. To get started with a Sage 50 consultant today, call us at 800-475-1047 today or email us at solutions@jcscomputer.com.

 

Manufacturing Inventory Accounting

Manufacturing Inventory Accounting: What Happens to an Inventory Account When Materials Are Bought, Requisitioned, Manufactured, used in jobs or Sold?

If your company is a construction, distributor or manufacturing business using software and are seeking information to help understand how it should work within the software system or if you are new to these processes and are looking for better inventory control, this will help.

This document is intended to give you a high-level view and help you understand what happens to quantities on hand when items are bought, requisitioned, manufactured and/or sold. Each part of the process has its own best practices and its’ own ‘accounting under the hood’ during these various phases of inventory control. Let’s get started. Here is a simple rundown to help you understand these concepts from beginning to end.

Purchases

Individual items are often referred to as raw material or components in a manufacturing environment; products for distribution; or materials for a Job. They are typically purchased through the use of a purchase order and received at the dock. The quantity on hand is increased by the number of items received and the cost of each item is typically tracked by some predetermined costing method. Tracking allow us to see the quantity and value of our inventory as an asset. Later, that tracking will also provide the tools to assign costs when they are used in manufacturing or are used on a job. Ultimately, that tracking allow us to assign a cost when completing a sale, thus granting the ability to view the profit that has been realized. Along the way, we can keep up to date with information about quantities bought, sold, used, expended, transferred or lost to mishap. Some business requires traceability for the movement of items throughout the entire manufacturing process or from purchase to sale. Manufacturers often refer to this as “quote to cash.” The receipt of items at our dock, should increase the value of our inventory while at the same time establishing either a liability for the purchase or an accrual, pending receipt of a future accounts payable invoice.

Purchased items may also be delivered directly to a client location. Usually when the documentation for this type of delivery is recorded, it is considered a ‘drop shipment’, and we are concerned mainly with recording the increase in our material expenses. When the delivery client location is a job address however, we may rather increase an asset amount in a work in process account.

Items may also be managed as non-stock when we are either, not concerned with tracking it’s value, don’t need to worry about quantities on hand, stock availability, profitability per item or sale or where tractability and/or more exacting profitability figures are not required. Sometimes it makes sense to use nonstock items when the cost of the item is so small that managing the process of recording the information is not cost effective.

When making the purchase where a vendor ships product to you and allows you to pay on account, the accounting that occurs is an increase (or debit) to inventory with a corresponding increase (or credit) to a liability account. If an invoice is received with the materials or goods, the liability would be recorded as an accounts payable amount, but if not, it is accrued in a pending payables, purchases clearing account or Accounts payable accrual account depending on your companies terminology to be relieved or transferred to accounts payable when the invoice document actually arrives and is recorded.

When making a purchase where cash, check, debit or credit card is used to directly buy inventory, the offset to an increase (debit) in inventory value would either decrease (credit) our cash in the bank or increase (credit) in the liability to our credit card company. If you are using a credit card to make the purchases, you may also want to reconcile the credit card accounts when the statement from the vendor arrives.

When recording the completed shipment of items that were ‘drop shipped’ to our clients, we usually increase (debit) our expense for the goods we purchased unless the materials were delivered to the site of our ongoing job, the transaction would most likely increase (debit) a work in process (WIP) account. Both of these would be offset appropriately based on the terms of cash or credit purchase provided by the supplier and as already outlined above.

Material Requisition, Issues, Usage or Assembly:

The first step of production, when manufacturing, is the purchase of the items or materials needed. These materials may be purchased to stock for later use during the manufacturing process or directly to a job for a project. Material issue, is the movement of materials from stock into the production process, typically for a specific job, project or production run. The entire production process is recorded in the financial records of the company, and each stage of the process may have its own journal entries. This doesn’t always mean that the overall value of inventory actually changes. Learning about the journal entries that take place during the course of the production process can help you understand the effects of production on your overall financial position. A work in process (WIP) account, may be used to track the value of materials that have been specifically earmarked for a job to help segregate them from items that are available directly for sale, while still tracking costing and other information to allow for reporting on budgeting, management of resources, traceability and ultimately to allow for profitability reporting and budgets versus actual expenses and revenue.

Issuing materials, also known as putting materials into production, is the second step in the production process. Normally, company’s account for direct and indirect materials separately. Direct materials, meaning materials that can be directly traced to finished products, are recorded as an increase (debit) in work in process and a decrease (credit) in inventory account associated with that material at the time they are issued to a production run or job. When recording indirect materials, those that cannot be directly traced to finished products, we instead increase (debit) a manufacturing overhead account while decreasing our materials inventory. Because the process of issuing direct materials is a transfer between two inventory accounts, the overall inventory balance on the financial statements may not change during the lifecycle of any given production step.

Manufacturing of Finished Goods is closely related to job costing, but there are a few major differences.

Manufacturing typically utilizes the demands on inventory to assist in the timing of the inventory procurement process. To manage manufacturing production, we may need shop floor controls and the ability to track the status of items as the process of production plays out. Steps in the manufacturing process may need to be tracked to derive required item status information or when coupled with workstations, provide a framework to assist with capacity planning. Jobs tend to be broken into steps called phases and cost codes, but here the statuses we need to track are usually a % of completion. Specific instructions or CAD drawings needed for a production step may sometimes be more detailed than phase plans found in job costing. Both manufacturing and job costing may benefit from the ability to establish estimated revenue, estimated expenses and to track and manage change orders. Bar code capabilities may also provide a great assistance in a manufacturing environment by helping to manage item movement during the receiving, issuing, usage or consumption to the job and shipping steps.

When items are used during the manufacturing process, most often the material used in production are depleted by one of three methods.

Bill of Materials Assembly/Production:

This is a good choice if production management does not require work in process tracking and either the items you make have a consistent bill of materials or are repetitively manufactured items with only minor alterations to the materials needed. At the point where production is recorded, meaning the finished item is completely assembled and ready for shipment to the customer, the quantity of component items, defined by the bill of materials, are removed from inventory and finished items are increased by the quantity produced. The cost associated with the finished quantity is a factor of the cost of materials used. At the most basic level, the cost of the materials used is simply moved from the raw materials inventory account to the finished goods account. In more comprehensive systems, additional costs, like labor or overhead, may also be included in the cost associated with the finished product. These additions may be added as additional costs to increase the finished product inventory account, but would come out of an overhead or a labor used in manufacturing account, rather than a raw materials inventory account.

Work Orders or Work Tickets:

This method is most effective if you have manufacturing process where there is a significant need to manage inventory demand over time. In other words, if production takes a long time to complete and items need to be accounted for as they are used, or if your need to correlate multiple distinct production runs in order to properly manage material demand, work tickets provide an excellent tool. Work order systems often also proved tools to allow for variation on a standard bill of materials.

Work order systems may include the ability to predefine the steps needed in the manufacturing process and allow for the printing of ‘shop travelers’ or other documents to help manage the process through all of its stages. At some point, in this type of system, the cost of materials are moved from their raw materials inventory to a work in process tracking account. Once goods are completed, the costs are transferred out of the work in process account, decreasing (crediting) it’s balance. At the same time the total cost of production is used to increase (debit) the finished goods inventory. With complex bills of manufacturing involving multiple steps, the work in process account may have been increased as each step is completed and other costs like overhead or labor are recorded. Like a material issue, final assembly is often recorded as a transfer between inventory sub-accounts, and the overall inventory balance does not change. For more complex production, inventory accounts may have increased as the additional costs associated whit each completed step are recorded. The cost of goods manufactured will remain in the finished goods inventory account until the goods are sold.

Kitting

The last method is often called kitting. In this method when a finished product is invoiced, special behind the scene tools in the system, decrease the materials inventory by the quantities defined for the kit, based on their cost as tracked by the inventory system. In this instance there is a decrease (credit) in the materials inventory account with a corresponding increase (debit) in our cost of goods sold account with no intervening involvement of a finished goods inventory account.

Additional Cost of Manufacturing

Costs, other than materials, may be included as part of any of the depletion methods to increase the cost of a finished product in stock or increase the costs associated with a project or job when it is sold. These additional costs may include, labor, labor burden, subcontracted work, overhead or equipment use. Often these costs have been accounted for in other ways, so the GL accounts affected usually decrease (credit) an expense account in order to correspondingly increase (debit) the inventory account associated with the finished product. Many manufacturing systems, when the process is being tracked on Work Orders or Work Tickets, allow the definition of the operations that take place and work stations where operation steps are performed to produce a finished product. As reporting takes place on the status of these operational steps, these systems often record the the accumulation of these additional cost while allowing for oversite and management. Defining work stations and operations also provide a framework for the scheduling or available resources allowing management to identify conflicts for those resources and providing a timetable to completion. When bills of material (BOM) are combined with the management of operations and shop floor resources, it is often referred to as a bill of manufacturing. In a simple BOM assembly or kitting situation, these additional costs are often standardized and added in to the bill of materials.

Sales and Cost of Goods Sold

Deposits to jobs or manufactured items normally should be reflected as a deposit to the job, project or order. Deposits generally increase (debit) our cash in the bank while at the same time, increase (credit) our liability in a customer deposits account of some sort. The deposit should be applied to the balance due from the customer usually during the final part of the billing cycle. In a manufacturing situation, this is usually when the item is shipped while in a job cost situation where billings may be periodic or incremental, it could take place at any time up until long after the final billing when the job or project is finally considered fully complete. When the deposit is finally applied, the amount decreases (debits) customer deposits while at the same time, decreases (credits) accounts receivable, reducing the balance due from the customer.

The final step in a manufacturing environment is the sale of the items produced. The quantity being sold is shipped and recorded as such on an invoice to deplete the quantity on hand for each item being shipped. The revenue is recognized as an increase (credit) to the appropriate sales account while also increasing (debiting) accounts receivable and the balance due from the customer. Since inventory is being depleted, the inventory account is also decreased (credited) by the cost of the item and that same cost, will increase (debit) the cost of goods sold (COGS) account associated with that item. The cost associated with the sale is dictated by a costing method assigned to the product being sold.

The difference between revenues and cost of goods sold is the gross profit on the sale. If the increase (credit) to our sales account is more than the increase (debit) to our cost of goods sold account, the sale resulted in a profit.

 

Job Costing needs tend to differ from manufacturing in the following areas:

Both Manufacturing systems and Job Cost may require that labor, labor burden, overhead, sub-contracted services or labor, and equipment costs be rolled into the cost of what is being sold. Both often want to be able to estimate or budget their work and duplicate or review prior work for to achieve more competitive sales while insuring a profit. Each has a hierarchy of applied cost. Though highly individualized for every business entity, Manufacturing tends to rank materials as their most important cost, followed by an overhead consisting of labor, equipment, labor burden and transportation while sometimes including subcontracted services. In Job Costing time (both supplied and subcontracted labor and equipment) followed by materials is the usual hierarchy followed by labor burden and other overhead costs.

They both may also want to break their work into smaller steps for better reporting and management with the added benefit of incremental reporting providing the potential for forecast possible issues in time to make changes prior to the completion of the work. For Manufacturing, those increments are often broken down into work centers or operations, while in Job Costing we see breakdowns called phases and cost codes.

In Manufacturing systems, we generally bill customers for the product that was manufactured while Job Costing might follow one of 3 main billing methods; percent of completion, completed jobs and time and material.

The term Job Costing is most often used in the construction industry. Often the project lifecycle is longer than in Manufacturing. Labor and outside service along with actual material tend to be posted to a job during the period in which the expense occurred and comparison reporting between the actual expense and budget are review on a regular basis. Some job costing applications also use a WIP (completed job) type accounting method. Most Job Costing applications are geared towards cost tracking and often do not assist a business in the procurement process or scheduling process.

In the completed jobs accounting method, actual costs are accumulated in to WIP accounts during the life cycle of the job. Once the job is completed and the final invoice to the customer is created, the accounting entry increases (debits) accounts receivable while increasing (crediting) revenues. At the same time the expenses that have been accumulated in WIP are removed (credited) from WIP and added (debited) to the appropriate expense accounts. Both these transactions are normally recorded in the same accounting period.

In percentage of completion jobs, billing is based on the percentage of actual work has been completed for a Job. This could be based on a comparison of estimated vs actual expenses as tracked in the system or on a percent complete as reported from the jobsite. For example, if $500 of an estimated $2,500 in expense costs have been spent or if the project manager has reported and had approved completion of 20% of the work, the 20% of the total sale amount can be billed for the billing cycle. This billing method may use a WIP type accounting method, where cost are accumulated in WIP and redistributed at the time of billing as in the completed jobs method, or the costs may simply be expensed as they occur. When expensed directly, each invoicegenerated for a job, will only increase (debit) accounts receivable while increasing (credit) revenues.

In Time and Materials (T&M) Jobs,  all costs are directly expensed to the job. From the tracked time costs, like labor, subcontracted services or equipment usage, and tracked material costs, are used to bill the customer. Revenue is recognized when each customer invoice is generated and expenses are recorded at they are received.

 

Accounting Business Solutions by JCS specializes in inventory control software, assisting contractors, distributors and manufacturing companies in leveraging technology. Our consultants are certified in Quickbooks and Sage software, including Sage 50 and Sage 100, as well as manufacturing add-ons such as JobOps and MiSys Manufacturing. Call us today at 800-475-1047 today!

Sage 100 Month End Checklist, Sage 50 month end checklist, Sage 100 support, Sage 50 support

Sage 50/Sage 100 Month-End Checklist

One of the main benefits of using an accounting or an ERP system is the organizational advantages offered by these products. Whether you are using Sage 100 ERP or Sage 50 software, it is crucial to keep your monthly finances accurate and up-to-date. Never fall behind with our handy Sage 50/Sage 100 Month-End Checklist!

 

Sage 50/Sage 100 Month-End Checklist:

  • Enter your sales and purchase invoices for the month.
  • Enter all monthly payments and receipts from check stubs and paying-in slips.
  • Enter direct debits, ACH transfers, checks, and so on from your monthly bank statements.
  • Reconcile bank accounts for the month, including credit cards.
  • Enter journals or run wizards for accruals, prepayments, depreciation and so on.
  • Depending on where you live and your payment schedule, calculate, file, and pay your monthly state and federal employment and sales taxes.
  • Run Aged Debtors and Aged Creditors reports for the period.
  • Run Profit and Loss and Balance Sheet for the period.
  • Run month-end wizard (Tools→Period-End→Month-End).

 

Sage 100 Month-End Checklist, Sage 100, Sage 50, Sage 50 Month-End Checklist, Sage 100 support, Sage 50 support

If you need help learning how to use these helpful Sage 50/Sage 100 month-end features, call the certified Sage consultants at Accounting Business Solutions by JCS today! Our experienced, professional staff offers a full range of Sage software consulting services, including Sage 100 support, Sage 100 classes, Sage 100 data repair, Sage 50 support, Sage 50 classes, and Sage 50 data repair for all years and versions of your particular Sage product. Our nine locations, which include Detroit, MI, Chicago, IL, Charleston, SC, St. Louis, MO, Mandeville, LA, Dallas, TX, Naples, FL, Atlanta, GA, and Sacramento, CA, are conveniently located throughout the United States to serve you better. We also offer remote assistance and in-house help. Get help with your Sage 100 or Sage 50 software by calling 800-475-1047 today, by emailing us at solutions@jcscomputer.com, or by filling out our contact form. Your success is our goal!

sage 100, sage 100 support, sage 100 era, sage 100cloud, sage 100c, sage 100 manufacturing, sage 100 consultant, sage100, sage 100 classes, sage 100 training

Sage 100 2018.3: Register Changes

Every few months, Sage releases an update for their Sage 100 2018 software which includes many useful changes and bug fixes to help your Sage 100 product run more efficiently. The most recent version, Sage 100 2018.3, includes many helpful changes to the Register, including but not limited to:

  • Job Estimate Printing with Print Estimate Recap selected now calculates Overhead and Profit calculations correctly on the Estimate Recap
  • Job Transaction Detail Report no longer inserts a Page Break between each job when “Page Break by Job” is unchecked in report options.
  • Corrected issue with Cost Code unit price and unit cost being truncated in Job Posting Entry.
  • Fixed wrong print sequence of Job Cost Job Daily Transaction Register and Job Cost Daily Transaction Register
  • Corrected issue with navigation buttons not refreshing Revised Contract Amount display in Change Orders tab when moving between records.
  • Error “xx-xx-xxx is not on file” after migrating data to v2018 with a Cost Code length less than 9 characters.
  • Job Trans Detail History Report no longer inserts a Page Break between each job when “Page Break by Job” is unchecked in report options. And transactions are now sorted in date order under the Cost Code.
  • The Error “The Burden Job Type generated an invalid Cost Code” no longer occurs when updating Payroll with Burden Allocation defined and using a Cost Code less than 9 characters.
  • Overhead Allocation Register (Monthly or Daily) now updates to G/L in summary format.
  • Job Billing Selection no longer duplicates Time and Material job transactions if the transaction date is less than or equal to the module date.
  • Job Billing History Report Current Balance column no longer displays ##### if the Current Balance exceeds $999,999.99
  • Direct Cost Job Posting Register and Job Daily Transaction Register no longer prints ######## when amount is 1,000,000.00 or above.
  • The correct Cost Code description now prints on the Job Cost Code Detail Report.
  • Negative amounts entered in Job Posting Entry now post correctly to the G/L.
  • Last invoice from previous job are appearing on the Job Masterfile Maintenance on Billing History tab for new Job if same customer.
  • AP Check Register no longer hangs during update when integrated with Job Cost.
  • An Error 65 CI_JobNo_VAL.pvc 69 no longer occurs in Job Billing Selection or Job Billing Data Entry.
  • The Cost Code Format is no longer invalid when attempting to enter different segmented Cost Code in Cost Code Maintenance in Sage 100 2018.
  • The message changed as below on the prompt message box.

 

sage 100, sage 100 2018, sage 100 2018 register, sage 100 support, sage 100 consultant, sage 100 trainingAccounting Business Solutions by JCS offers a variety of Sage 100 support, training, and data repair services to assist you with any problems you may be having with the Register in Sage 100 2018.  Our certified Sage 100 consultants have years of experience helping businesses just like yours maximize the efficiency of their Sage 100 software. To learn more about Sage 100 software, call us at 800-475-1047 or email us at solutions@jcscomputer.com. Your success is our goal!

To download the Sage 100 2018.3 update, visit the Sage 100 2018 download portal here.

sage 100, sage 100 support, sage 100 era, sage 100cloud, sage 100c, sage 100 manufacturing, sage 100 consultant, sage100, sage 100 classes, sage 100 training

Sage 100 2018.3: Accounts Receivable Changes

Every few months, Sage releases an update for their Sage 100 software which includes many useful changes and bug fixes to help your Sage 100 product run more efficiently. The most recent version, Sage 100 2018.3, includes many helpful changes to Accounts Receivable, including but not limited to:

 

  • Error “The Cash Receipts entry files are empty” no longer occurs when updating an A/R Cash Receipts batch where one deposit within the batch was transferred to a new batch.
  • Running the Credit Card Settlement Report no longer returns a communication error.
  • Printing the Credit Card Settlement report no longer returns a communication error (support for Error 20 AR_AgedInvoiceReport_rpt.pvc 386 is no longer occurred when previewing/printing the Accounts Receivable Aged Invoice Report.
  • Correct amount for discounts allowed and A/R GL accounts posted to GL shown on Sales Journal Recap by Division when printing/updating.
  • “Customer On Credit Hold” text font color is now red in Customer Maintenance version 2018.
  • Fix Error: “<Customer Number> is in use by another user and can only be viewed” in Price Level by Customer Maintenance
  • Error 47 CI_CustomerFormatter.pvc 100 is no longer occurred when entering cash receipts for Cash customer
  • Schedule text is not displayed over Exemption No text on Sales Order Invoice Data Entry Header panel when Sales Tax Reporting is disabled.
  • Fixed Error: “Payroll is not installed on this system” in AR Salesperson Maintenance when clicking Link button if Payroll is not installed.
  • Schedule text is no longer displayed over Exemption No text on Sales Order Invoice Data Entry Header panel when Sales Tax Reporting is disabled
  • The Error: “65 CI_AuditTracking.pvc 355” is not occurred when saving new credit card in customer maintenance with AR Audit tracking enabled.
  • The Cash Receipts records are updating to AR or Job Cost correctly.
  • Wrong amount for discounts are not allowed and AR GL accounts posted to GL shown on Sales Journal Recap by Division when printing/updating.

Sage 100, Sage 100 2018, Sage 100 2018.3, Sage 100 Accounts Receivable

Accounting Business Solutions by JCS offers a variety of Sage 100 support, training, and data repair services to assist you with any problems you may be having with Accounts Receivable in Sage 100 2018.  Our certified Sage 100 consultants have years of experience helping businesses just like yours maximize the efficiency of their Sage 100 software. To learn more about Sage 100 software, call us at 800-475-1047 or email us at solutions@jcscomputer.com. Your success is our goal!

To download the Sage 100 2018.3 update, visit the Sage 100 2018 download portal here.

quickbooks, quickbooks support, quickbooks classes, quickbooks training classes, quickbooks consultant, discounted quickbooks software, quickbooks online

What’s New in Quickbooks 2019

The highly anticipated Quickbooks 2019 software was released on September 17, 2018.  Quickbooks 2019 is full of helpful features which improve upon prior versions of Quickbooks software, including Quickbooks 2018 and Quickbooks 2017. Each week, we will be highlighting just a few of these new and improved Quickbooks 2019 features.

Quickbooks 2019 features include….

More reliable sick and vacation time tracking.

In the past, it was easy to overpay employees for sick and vacation benefits in Quickbooks Payroll. In Quickbooks 2019, Intuit has included a helpful warning when an employee has used up their sick or vacation time. In fact, the new pay stub format includes a column for accrued, used, and available sick and vacation time so that both employer and employee are clear on what has been used.

Inventory Enhancement

In prior Quickbooks versions, we often came across issues where the balance sheet did not match the Inventory Item Summary report. By default, the inventory item summary will not list inactive items, but the inventory total would include inactive items as shown in total on the balance sheet. In Quickbooks 2019, if you try to mark an inventory item inactive but it still has a quantity on hand balance, you will receive  an error message. Additionally, the Inventory Valuation Summary report now shows you which items you have inactivated.

Track Your Outstanding Invoices

The new version of Quickbooks now includes a consolidated snapshot of your invoices. It also allows you to check when your invoice has been viewed so you can follow up on A/R balances easily.

Transfer of Credits for Customers and Jobs

Quickbooks 2019 allows you to apply credit memos across all jobs rather than one specific job, saving you a ton of time and frustration. The new account is called “Account for credit transfer”  and is inactive and zeros out.

 

 

Are you interested in learning more about Quickbooks 2019 software? The certified Quickbooks ProAdvisors at Accounting Business Solutions by JCS offer Quickbooks support, training classes, data repair, and Quickbooks custom reports. To upgrade to Quickbooks 2019 or to learn more, call us at 800-475-1047 or email us at solutions@jcscomputer.com. Your success is our goal!

sage 100, sage 100 support, sage 100 era, sage 100cloud, sage 100c, sage 100 manufacturing, sage 100 consultant, sage100, sage 100 classes, sage 100 training

Sage 100 2018.3: Accounts Payable Changes

Every few months, Sage releases an update for their Sage 100 software which includes many useful changes and bug fixes to help your Sage 100 product run faster and more efficiently. The most recent version, Sage 100 2018.3, includes many helpful changes to Accounts Payable, including but not limited to:

  • The DiscountAmt field in AP_CheckHeader file now shows the total discount for all invoices included on the check.
  • Vendor Maintenance Invoice Inquiry feature under ‘More’ displays invoices generated from Purchase Order Invoice amount now matches the Net Invoice Amount displayed on the AP Invoice History drill down screen.
  • Added required 1099 boxes for calendar year 2017
  • Tax Account Number is no longer incorrectly required in eFiling and Reporting 1099 Misc Setup Wizard
  • Help for A/P Invoice History Inquiry has been enhanced.
  • Unable to enter Amount on Credit Memo in Job Cost Distribution Detail when reversing an electronic payment is now fixed.
  • AP invoice entry – Get ‘The Vendor Number is no longer required’ message when launching vendor maintenance from hyper link and the vendor number isn’t blank.
  • Accounts Payable Adjusted Invoice No Longer Paid twice.
  • In Form 1099 Tax eFiling and Reporting for 1099-MISC forms, a Tax Account Number is no longer required if there is no state income to report.

 

Accounting Business Solutions by JCS offers a variety of Sage 100 support, training, and data repair services to assist you with any problems you may be having with Accounts Payable in Sage 100 2018.  Our certified Sage 100 consultants have years of experience helping businesses just like yours maximize the efficiency of their Sage 100 software. To learn more about Sage 100 software, call us at 800-475-1047 or email us at solutions@jcscomputer.com. Your success is our goal!

To download the Sage 100 2018.3 update, visit the Sage 100 2018 download portal here.

sage 50 bank reconciliation

How do I perform a bank reconciliation in Sage 50?

A bank reconciliation is used to ensure that the transactions you have entered into your Sage 50 software match up with the transactions on your bank statement. Prior to performing a bank reconciliation in Sage 50make sure that all of your sales invoices, checks, supplier invoices, recurring charges, and receipts have been posted for the time period you are trying to reconcile. Checking this prior to actually performing the bank reconciliation in Sage 50 will save you the headache of trying to find any variance you may encounter when the reconciliation is completed.

  1. From the Sage 50 Bank Accounts module, select which account you want to reconcile by clicking on the “Reconcile” icon. You will then see the Statement Summary window, where you will need to enter the following:
    • A title for the bank reconciliation
    • The bank statement balance you are reconciling to
    • The date of the statement
  2. After clicking “OK”, the bank reconciliation screen will open and you’ll be able to use your bank statements to tick off all the transactions that are currently showing in Sage 50 against the bank statements themselves. If any items have not been selected, such as direct debits or  receipts, add them by using the adjustment button and selecting the appropriate type of payment or receipt.
  3. When you are able to match all of the items in Sage 50 with an entry on your bank statement, double check that the “Difference” box in the bottom right hand corner is zero. If the variance is anything other than zero, the first thing you should check is that you have entered the correct bank statement amount.  If those numbers are correct, you’ll have to compare the bank statement to the items you have checked off on the Sage 50 reconciliation screen.
    • Common errors include double entry of a particular transaction, accidentally selecting a transaction which is out of that particular date range, or even a transposed amount somewhere within your Sage 50 transactions.
    • One way you can quickly find errors is to compare the bank statement to the Sage 50 reconciliation screen from the most recent transaction to the oldest transaction (so backwards).
  4. If you are confident that your figures are correct and the “Difference” box in the bottom right hand side of your screen is zero, press “Reconcile.”
    • Sage 50 automatically saves a copy of your bank reconciliation in the archives if you need to revisit it at a later date.

 

For more Sage 50 training or to learn more about performing a bank reconciliation in Sage 50 accounting software, visit Accounting Business Solutions by JCS or call us today at 800-475-1047!

Sage 50 System Requirements 2018

Sage 50 System Requirements – 2018

Support – Training – Consultant – Reseller

Find the system requirements for Sage 50 2018. For further information or questions regarding your Sage 50 or system requirements please contact one of our certified experts 800.475.1047 solutions@jcscomputer.com.

Minimum System Requirements

  • – Internet access for all online features/services
  • – 2.0 GHz processor for single user and multiple users
  • – 2 GB of RAM for single user and multiple users
  • – At least high-color (16 but) SVGA video; Minimum resolution: 120×800, Preferred Resolution: 1440×900 or higher; small fonts/DPI settings required.
  • – 1 GB of disk space for installation
  • – Internet Explorer 9.0, 10.0, ad 11.0 supported (version 11.0 and higher with Sage Payroll Solutions, Sage Payment Solutions and other Connected Services integration)
  • – Windows® 7, Windows 8, or Windows 10 with the latest updates from Microsoft installed
  • – Windows® .NET Framework 4.5.2; requires an additional 280 MB to 850 MB (.NET 4.6 with Sage Payments Solutions integration)

Integration/compatibility requirements

  • Adobe® Reader® 11.0 required
  • Office 365 Integration – Requires Office 365 Business Premium
  • Printers supported by Windows 7, Windows 8 or Windows 10
  • In-product demos require Adobe® Flash® Player 11 or greater (version 18 or higher strongly recommended)
  • Excel®, Outlook®, and Word® integration requires Microsoft Excel, Outlook, and Word 2007, 2010, 2013, or 2016 (32-bit)

Multiuser

  • 2 GB of disk space for installation of components on server
  • Multiuser environments are supported in Sage 50 Premium Accounting and higher
  • Multiuser mode is optimized for Windows Server 2009, Windows Server 2012 or Windows Server 2016 client-server networks; Windows 7, Windows 8, or Windows 10 peer-to-peer networks
  • A maximum of 5 licensed named users is allowed for Sage 50 Premium Accounting and 40 named users for Sage 50 Quantum Accounting; a named user account is granted a license when selected in the user maintenance screen

Terminal Services

  • Terminal Server requires additional memory when more than one user is running under Windows Terminal Services
  • Windows Server 2008, Windows Server 2012 or Windows Server 2016 along with Remote Desktop Connection or Remote Desktop Web Connection client is required to run in a Windows Terminal Services environment; no more than 5 named users for Sage 50 Premium Accounting or 40 named users for Sage 50 Quantum Accounting

Other

  • Customer registration and acceptance of License Agreement for Sage Accounting software products

Recommended System Configuration

  • 2 GB of RAM for a single user and 4 GB for multiple users
  • 4 GHz processor (Intel Core i3 and higher) for single user and multiple users

For more information on Sage 50 give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Sage 50, Sage 50c, Sage 50 Support, Sage 50c Support, Sage 50 Consultant, Sage 50c Consultant, Sage 50 Reseller, Sage 50c Reseller, Sage 50 Training, Sage 50c Training, Sage 50 System Requirements, Requirements for Sage 50, Sage 50 upgrade, Sage 50C upgrade

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

X