QuickBooks Month End Close

Quickbooks Month End Close Procedure and Checklist for Small Business Accounting

Month End Close Tips and Tricks

 

What is a Quickbooks month end close? Basic steps include

  • Record deposits
  • Entering vendor payments
  • Bank Reconciliation
  • Review financial balances
  • printing and saving month end reports
  • Lock the current accounting period.

 

Each month Small Businesses should complete these steps to confirm all transactions are entered and reflected in the financial reports. This process when performed in a timely manner will support decisions made for the business based on financial reports.

Tips and tricks

The bank reconciliation is one of the most important steps. Remember to complete this each month in your QuickBooks company file.

QuickBooks accounts to reviewed and reconciled each month

  • Cash
  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Gross Wages

If you are a larger company there may be additional accounts that need to be reviewed for accuracy each month such as fixed assets, prepaid expenses, loan accounts and tax liabilities. If you are distribution or manufacturing company it may include WIP, Finished goods and cost of goods sold. For a month end close checklist follow the links below to request a month end close checklist in excel for your small business.

Request QuickBooks Month-End Close Checklist

View QuickBooks Quarter End Close Checklist

View QuickBooks Year End Close Checklist

Here’s how to close the books:

  1. Choose the Gear icon and select Company Settings.
  2. Choose Advanced.
  3. In the Accounting section, click on the Edit icon.
  4. Check the box labeled Close the books.
  5. Enter a closing date. …
  6. Decide what you want users to see if they try to save a transaction that is dated prior to the closing date:

For more information and support on Small Business Accounting Software visit Accounting Business Solutions by JCS and for services on Sage Software Timeslips visit www.timeslipssupport.com

Sage 100 month end close

Sage 100 Month End Close

How to perform Sage 100 Month End Close Procedure and Checklist

for Sage 100 ERP Small Business Accounting

Month End Close Tips and Tricks

Closing Steps

In Sage 100 the most 5 basic steps include entering all deposits and checks, bank reconciliation, reviewing of financial balances, printing and saving reports and finally closing each module and then beginning entry of  transactions into the new accounting period.

Module Information

Every individual module in Sage 100 has its own steps that should be performed prior to the close. All transactions must be updated to the module and to the general ledger.  By following an organized list each month you will keep your system in balance and moving forward.

Review

Small Businesses walk thru these steps each month end to make sure financial reports are accurate. The result of completing each month in a timely manner is so that the owners can determine profitability each month during the year. The bank reconciliation which is included as a part of the month end close steps confirms all transactions for the monthly period were recorded and is a critical part of the process.

Tips and tricks

Sage 100

Five accounts to reviewed and reconciled each monthly:

  • Cash
  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Gross Wages

If you are a larger company there may be additional accounts that need to be reviewed for accuracy each month such as fixed assets, prepaid expenses, loan accounts and tax liabilities. If you are distribution or manufacturing company it may include WIP, Finished goods and cost of goods sold. For a month end close checklist follow the links below to request a month end close checklist in excel for your small business.

Sage 100 Small Business Month-End Close Checklist

Request Month End-Close Excel Checklist

Sage 100 Small Business Quarter End Close Checklist

View Quarter End Checklist

Sage 100 Small Business Year End Close Checklist

Review Year End Close Checklist

For more information and support on Small Business Accounting Software visit Accounting Business Solutions by JCS and for services on Sage Software Timeslips visit www.timeslipssupport.com

pros and cons of Sage 50, sage 50 Accounting, cost of Sage 50 accounting software, sage software, sage 50cloud reviews

Sage 50 Month End Close

How to perform a Sage 50 Month End Close

Steps to complete a Month End Close Procedures and Tips and Tricks

for Sage 50 Small Business Accounting

Month End Close Tips and Tricks

What is a month end close in Sage 50? The 6 basic steps include

  • Entering deposits
  • Recording checks
  • Complete Bank Reconciliation
  • Review financial balances
  • Print reports
  • Change to the new accounting period

The bank reconciliation which is included as a part of the month end close steps confirms all transactions for the monthly period were recorded and is one of the most  critical part of the process.

 

Small Businesses walk thru these steps each month end to make sure financial reports are accurate. The result of completing each month in a timely manner is so that the owners can determine profitability each month during the year. Often this is the basic for future financial decisions.

Sage 50 Tips and tricks

For Sage 50 users on any version

  • Sage 50 Quantum
  • Sage 50 Premium
  • Sage 50 Pro

5 accounts that need to be reviewed and reconciled monthly are:

  • Cash
  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Gross Wages

If you are a larger company there may be additional accounts that need to be reviewed for accuracy each month such as fixed assets, prepaid expenses, loan accounts and tax liabilities. If you are distribution or manufacturing company it may include WIP, Finished goods and cost of goods sold. For a month end close checklist follow the links below to request a month end close checklist in excel for your small business.

Sage 50

Month End Close

What Steps are necessary to complete a Month End Close

Procedure and Checklist

for Small Business Accounting

Month End Close Tips and Tricks

What is a month end close? A high level overview of the 4 basic steps include entering all deposits and checks, reconciling financial balances, printing and saving reports and finally moving from the current month to the new accounting period.

Small Businesses walk thru these steps each month end to make sure financial reports are accurate. The result of completing each month in a timely manner is so that the owners can determine profitability each month during the year. The bank reconciliation which is included as a part of the month end close steps confirms all transactions for the monthly period were recorded and is a critical part of the process.

Tips and tricks

Review and reconciled these 5 accounts each month

  • Cash
  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Gross Wages

If you are a larger company there may be additional accounts that need to be reviewed for accuracy each month such as fixed assets, prepaid expenses, loan accounts and tax liabilities. If you are distribution or manufacturing company it may include WIP, Finished goods and cost of goods sold. For a month end close checklist follow the links below to request a month end close checklist in excel for your small business.

Request – Small Business Month-End Close Checklist

Small Business Quarter End Close Checklist

Small Business Year End Close Checklist

For more information and support on Small Business Accounting Software visit Accounting Business Solutions by JCS and for services on Sage Software Timeslips visit www.timeslipssupport.com

Sage 50 Bill of Material assembly sub-assembly work ticket build

Sage 50 Bill of Material

Sage 50 Bill of Material

I wanted to provide you with the process below which I think will help clarify how Sage 50 assemblies work. Hopefully this will be enough information to test thru the process with me or your team. The reason for my suggesting you walk thru this is to see the effort required to manage multiple level bill of materials.

When using multiple level bill of materials Sage 50 does not have the capacity to help you manage processes like scheduling, timing of demands for inventory items or shop floor routing and scanning capabilities. I bring these points up to confirm whether or not you might need those now or in the future to help your day to day operations become more efficient.

Sage 50 Bill of Material by Sage Software

Sage 50 can do multiple level bill of materials. Most often the challenge is that each sub assembly needs to be completed One at a time Before the final assembly can be completed and invoiced. Sage 50 does not have a back flush feature to allow

You to have clients request a delivery date and then manage the purchase order or build process to calculate the needed start date.

That said Sage 100 will step up to those needs. I can get a demo set up for this application so you can see the difference. The only conflict I am aware of in running Sage 50 and Sage 100 on the same serve is a potential conflict in the versions Of crystal reporting.

Discovery

Once we have a discovery call on Sage 100, I can then pull together pricing. If you wish I can get this on our schedule and we can offer estimates of conversion. We have migrated many clients in similar positions.

Yes, you can have some folks on Sage 50 and Some on Sage 100. A Consideration would be consolidated financials If you are doing that now using Sage 50 consolidated financials. That said Sage Intelligence may be able to provide this with a bit of setup. During the initial discussion we can him his opinion of Sage Intacct which may be Another option.

Let me know how you want to proceed. I am here to help. 800.475.1047

This is the process To set up inventory items

Set up all raw materials as inventory item class “stock”

Example of stock item is PTWheel-6

Set up all sub-assemblies as inventory item class “assembly”

Example of sub-assembly is PTHANDLE-ASM

Set up finished item – as inventory item class ‘assembly”

the components could be raw materials and/or sub-assemblies

Example of finished item is Red Lawn Mower

Item ID Item Description Qty Needed Qty on Hand Est Cost
Red Lawn Mower Red 18″ Reel Mower w/Tracking
. PTHANDLE-ASM 4′ Handle Assembly 1.00
. . PTHANDLE-BENT4 Handle – 4 ft bent 2.00 150.00 13.18
. . PTBOLT-1.5 Hex bolt 1.5″ 4.00 1,280.00 1.32
. . PTNUT- 5/16 Hex nut 5/16″ 8.00 1,180.00 0.56
. . PTBOLT-2 Hex bolt 2″ 4.00 900.00 1.36
. PTWHEEL-6 6″ Wheel 2.00 70.00 12.00
. PTWHEEL-10 10″ Wheel 2.00 70.00 16.00
. PTBLADE-99-9 16″ 5 blade 1.00
. . PTBLADE-16-5 16″ 5 blade 1.00 56.00
. . PTNUT- 5/16 Hex nut 5/16″ 6.00 1,180.00 0.42
. PTBOLT-1.5 Hex bolt 1.5″ 6.00 1,280.00 1.98
. PTNUT- 5/16 Hex nut 5/16″ 6.00 1,180.00 0.42
Red Lawn Mower Total  Cost 103.24

In this example the highlighted items in orange are the sub-assemblies – this is the report found at

Reports – inventory – bill of materials

In the items that are sub-assemblies or final assemblies there is an option on the bill of materials file tab

Which allows you to include or exclude the component items from the customer orders.

Sage 50 Bill of Material – the process to build your finished items

You can build using one of two available methods

  • Option a. Assembly Build
    • Found under tasks – Assemblies
  • Option b. Work Tickets
    • Found under tasks Work Tickets

Either of these you would need to

Step 1. Build the sub-assemblies one at a time using assemblies or work tickets

Step 2. Build the final product

This build of the final product is the step that rolls up all costs

The thing I like about work tickets is you have a printable document

Where you can add some steps to help identify the process and give direction

Then when the build is complete a document that can be provided to the front

Office to complete paperwork and invoicing

Then when you ship/invoice the final product you would have

  • Reports by customer
  • By item
  • Sales
  • Cost of Sales
  • Profitability

The only item needed on the sales order or invoice is the finished item

+ any misc. items you may wish to include

I would recommend

As in any product you not allow the inventory to have quantities on hand

Go into a negative level.

I am here to help give us a call 800.475.1047

Sage 50 Bill of Material assembly sub-assembly work ticket build

Sage 50 training and Sage 100 training for Sage Software available from Accounting Business Solutions by JCS

778 West Algonquin Road

Arlington Heights – Chicago, Illinois

Specialist in Sage Software

Sage 100 Intelligence Reporting

Sage 100 Intelligence Reporting

What is Sage 100 Intelligence Reporting? It is an advanced reporting tool able to access data from your entire ERP system. The Sage Business Intelligence module empowers you to quickly and easily obtain the information required from any module. You can then use it to help make decisions to drive improved operations. It is easy to organize your data in a relevant and logical manner for advanced reporting across your entire business.

Based on the familiar Microsoft® Excel® application, the Business Intelligence module lets you effortlessly create reports and analyze data. Empower your business with Sage 100 Sage Advanced Reporting.

Complex reporting made easy:

  • Sage Intelligence has a familiar Microsoft Excel interface
  • Easily customizable out of the box financial, sales, purchasing, and inventory report templates and dashboards

Transform your data into actionable information:

  • Powerful multi-dimensional analysis
  • Perform what if scenarios that go beyond just transnational data

Consolidate data from multiple companies and multiple sources

  • Single version of the truth
  • Simplify multi-company reporting

Access Strategically Meaningful Information.

Simply run one of the ten out of the box reports and start slicing and dicing information. If needed, customization and personalization of a template is a simple and straightforward process.

Boost productivity and Save Time and Money

Business Intelligence reduces manual Sage 100 reporting preparation, repetitive data extracts, and complex back-end data joins to provide you with up-to-date, accurate, and presentation-quality reports for informed decision-making.

Sage  Software Sage Intelligence reporting also offers Module-Level Security and Report-Level Security. If you need more powerful reporting other options include Sage near me:

  • Microsoft Sage Power BI
  • Sage Crystal Reports
  • Standard Sage 100 Reporting
  • Sage Dashboard Insights

Accounting Business Solutions by JCS provides support from our Sage Certified Consultants on a multitude of reporting options for Sage 100 Intelligence Reporting for Sage 100 Accounting. Give us a call 800.475.1047 or visit us for more information at www.jcscomputer.com or for Sage Timeslips Support.

Sage 100 Intelligence Reporting

#sage100Intelligencereporting, #sagepowerbi, #sagecrystalreports, #sage100reporting, #sagesoftware, #powerbisage100, #sageintelligencetraining, #sagenearme, #sage100accounting

Sage 50 Intelligence Reporting

Sage 50 Intelligence Reporting

Sage 50 Intelligence Reporting provides access into your data and is a powerful reporting tool helping you make data driven decisions helping you plan effective actions. Empower your team to help you drive growth and manage day to day operations.

Sage 50 Intelligence Reporting works seamlessly with Microsoft® Excel® to

  • Minimize repetitive and manual work
  • Allow the creation for in-depth customer, vendor and financial reports
  • Consolidate data from multiple databases, multiple companies/divisions
  • Analyze, view, customize and distribute reports using Microsoft® Excel®
  • Identify trends using customizable dashboards
  • Receive up-to-the-minute detailed transactions, summaries or account groupings
  • Provide staff with trend reports and other purposeful business information

Sage Intelligence Predefined Report Templates

Report Viewer Licenses, Report Manager Licenses, Report Designer Module, Connector Module are a part of the Sage 50 Intelligence Reporting suite. While there are many ways to customize the reporting functionalities of Sage 50 Intelligence it does provide a several predefined report templates.

Dashboard Analysis Template:  this is a 1 page summary of key business information features “Top N” Reporting on expenses, items, and customers.  Profit and Loss are also featured for the current month and year-to-date.

General Ledger Transaction Details Template:  shows the account transaction details, description, amount totals, dates, and reference.  This report allows functionality using Microsoft Excel PivotTable® and additional elements to be involved.

Customer Sales Template:  this report features sales information for customers including costs, gross profits per item and/or per customer and item sales.  PivotTable® allows for additional elements to be manipulated.

Vendor Purchases Template:  filter this report by items or vendors, it lists purchase information including cost and item numbers for any date range chosen.  PivotTable® allows for additional elements to be manipulated.

Inventory Status Template:   this report shows the item and quantities along with location.  PivotTable® allows for additional elements to be manipulated.

Financial Reports:  allows for the review of balances for your General Ledger for any financial period chosen.  Layouts are generated, subtotaled and grouped by financial category.  This report also allows customization using Excel.

Financial Trend Analysis Template:  gives you the information you need to see what comparative trending over a period of time.  This powerful feature allows you to pinpoint analysis of trends to the appropriate source it is driven by.

Financial Report and Consolidated Financial Report Template:  these reports are available immediately and show you comparative balance sheets and income statements for your chosen defined time period.  All reports offered in this template are fully customizable with Excel.

Sage 50 Intelligence Reporting Options:

Sage Intelligence reporting also offers Module-Level Security and Report-Level Security. If you need more powerful reporting other options include:

  • Sage Power BI
  • Sage Crystal Reports
  • Standard Sage 50 Reporting

Sage Software support contact:

Accounting Business Solutions by JCS provides support from our Sage Certified Consultants on a multitude of reporting options. Give us a call 800.475.1047 or visit us for more information at www.jcscomputer.com . For Sage Timeslips Support

Sage 50 Intelligence Reporting

Sage 50 Intelligence Reporting

#sage50Intelligencereporting, #sagepowerbi, #sagecrystalreports, #sage50reporting

QuickBooks Advanced Reporting, quickBooks advanced reports, quickbooks advanced training, quickBooks advanced reporting training, quickbooks reporting templates, quickbooks advanced reporting templates

QuickBooks Advanced Reports

QuickBooks Advanced Reports

Enterprise QuickBooks Advanced Reports are available with QuickBooks Enterprise version starting with 2017. The great news is that you can begin with one of the starter reports and get to work right away. The starter report will need to be imported into your Advanced Reporting for your installation. First download a starter report you should then open Advanced Reporting and click Report List. Lastly you can then click Import and open the saved starter report.

Some of the current Advanced Reporting templates include

  • Back Order Report
  • Paid Invoices by Sales Rep
  • Sales by city, job type and customer dashboard
  • Item Sales by item forecasting
  • Sales by item year over year
  • More Sales profitability by customer dashboard

This is the current link where you can down load a variety of starter Advanced Reporting options. View Here . It is important to know what when working with the QuickBooks standard reports you can only build a report using data from two types of tables.

QuickBooks Advanced Reports tables are:

Transactions: There are fields within each table that store transaction. Transactions can be journal entries, vendor invoices, vendor payments, customer invoices, customer cash receipts and so on.

List Names: These are the tables where demographic information for chart of accounts, inventory items, customers and vendor and so on.

What types of small businesses benefit from QuickBooks Advanced Reporting?

  • Financial Companies
  • Manufacturers – easy to use
  • Distributors – easy to set up
  • Service companies
  • Any business which needs more informative advanced reports.

Measure

The QBAR advanced reporting tool helps you use your QuickBooks data to create interactive reports. The advantage of this is so you can gain better insights into your financial and transnational information to help measure your success.

To learn more, visit our site www.jcscomputer.com or give us a call 800.475.1047 a Certified QuickBooks Consultant is available to help you with building custom advanced Reports. If you need assistance with  QuickBooks Support services read more.

#quickbooks, #quickbooksadvancedreports, #quickbooksadvancedreportingtemplates

Sage 100 Barcode

Sage 100 Barcode Software

How to understand solutions for barcode for Sage 100

Sage 100 barcode

Sage 100 Barcode

Automate your business and reduce errors with Sage 100 Barcode Scanning

Sage 100 ERP barcode for warehouse automation is designed to improve inventory accuracy and warehouse efficiency, allowing your businesses to focus on your operations. Learn More

Streamline your Sage 100 picking and packing process

Work smarter not harder with more reliable information you can speed up your inventory and warehouse processes with the Sage 100 Barcode module with mobile scanner integration.

Real time inventory information

With reliable, real-time Sage 100 inventory data, you can make quicker more informed business decisions.

What is a Sage 100 Barcode?

Typically printed on a label to identify a Sage 100 inventory item. A barcode is a method of representing part numbers / SKU data in a visual, machine-readable form. Barcodes represent characters of data by varying the widths and spacings of parallel lines. These barcodes, now commonly referred to as linear or one-dimensional, can be scanned by special optical scanners, called barcode readers.

What are barcode readers?

A barcode reader (or barcode scanner) is an optical scanner that can read printed barcodes, decode the data contained in the barcode. These can be directly attached to a hardware device, a rugged handheld scanning device and today smart phones.

What are UPC codes?

UPC codes are also knows as bar codes, but are issued by a central authority for a fee, and are thus unique in all the world.  If you’re not selling through a retail chain, you don’t need them.

Why is a Sage 100 barcode different from a Sage 100 Point of Sale software?

This is where you get into the POS software:  UPC codes must be ‘mapped’ to an internal or external stock number.  The UPC code may be similar, completely different, or nonexistent, for any given SKU.

There’s no mapping system built into Sage 100.  There’s an internal item ID, a 52-character part code, and a description.  The part code is search-able, but only from the beginning of the code.  The description is searchable on any character.  There a 5, 100 character ‘user’ fields in which you can put any data you like, but you can’t access any of that data from any invoice data entry screen.

Some Sage 100 inventory item numbers may be set up with the UPC, like “123456789 Scooby Doo Lunch Box”, or may have descriptions that contain the UPC, like “Scooby Doo Lunch Box 123456789”.   Once that’s all set up, you can program your bar code reader for the appropriate number of [TAB] entries to get it to the right place on screen.

Sage 100 Scanners

If you use a directly attached scanner you can plug it in to your hardware and scan a few bar codes in the item maintenance window, while adding lines to a sales order or purchase order. Most Barcode “Wedge” scanners do not have to be configured.  They have computer chip in them that decodes just about any barcode they come across.  Some are programmable, so that when you pull the trigger and they pick up a valid bar code, they will send (for example) [enter] [tab] <the ascii text in the barcode> [tab] [tab] to the program being used.

There are many different formats of bar code.  One of the easiest ways to print barcodes, is to use a “3 of 9” font in Windows.  (sometimes called Code 39).  There’s no checksum to calculate and print, all you need to do is put an asterisk (*) character at the beginning and end of the text that you want to encode.  (Obviously, you can’t use the asterisk as part of any barcodes). Requires an asterisk at the beginning and end of the ASCII text.   It’s start / stop codes are easy to add (i.e. in Excel)

Most barcodes have a start / stop code, and / or a Checksum.  The start / stop code is how the bar code reader knows it just saw the whole barcode.  The Checksum is how the reader knows it saw it correctly. Code 39 uses only a start / stop code.   Code 128 uses both.

What is Sage 100 Barcode Code 39?

Code 39 is a variable length, discrete barcode symbology. Code 39 uses characters that are displayed in this example it’s “=Concatenate(“*”,A1,”*”).  The Code 39 specification defines 43 characters, consisting of uppercase letters, numeric digits and a number of special characters. An additional character is used for both start and stop delimiters.

Code 39 is a bit more prone to misreads, since there is no checksum.  (but still less prone to error than manually entering these item ID’s. If you are looking at using Code 39 AND picking up UPC-A codes then the part number will need to be the UPC number unless your scanner can interpret both.

More about Code 39 can be found:   http://en.wikipedia.org/wiki/Code_39.

What is Sage 100 Barcode Code 128?

Code 128 is a high-density linear barcode symbology defined in ISO/IEC 15417:2007. It is used for alphanumeric or numeric-only barcodes. It can encode all 128 characters of ASCII and, by use of an extension symbol, the Latin-1 characters defined in ISO/IEC 8859-1.

Code 128 Requires a ‘Check Digit’ calculation included in the barcode. Also uses encoded start / stop codes that aren’t the same as each other. It is possible to have a scanner use UPC-A codes as long as the inventory item numbers are the UPC-A numbers unless your scanner can interpret both.

More about Code 128 can be found: http://en.wikipedia.org/wiki/Code_128 .

Where do I get more information on fully integrated Sage 100 Barcode Scanner?

Sage 100 now offers mobile barcode scanning with Sage Mobility for Barcode. Fewer errors, process more transactions easier and run leaner operations. Sage 100 scanners use pre-existing barcodes or it can generate new ones for you. Plus, it’s completely integrated with Sage 100 and automatically fills fields with the correct information when barcodes are scanned.

Sage 100 Barcode scanning integrates seamlessly with Enhanced Pick, Pack, and Ship and true physical inventory counts or cycle counts. For more information about Sage 100 Scanners for Sage 100 visit www.jcscomputer.com Or give us a call 800.475.1047. Put our 30 years of Sage 100 experience to work for you. Sage Timeslips Support

QuickBooks Barcode

QuickBooks Barcode Software

How to understand solutions for barcode for QuickBooks

QuickBooks Barcode

QuickBooks BarCode

Automate your business and reduce errors with QuickBooks Barcode Scanning

UGHH errors – Incorrect QuickBooks unit counts, mismatched SKUs, and human errors can all be reduced by doing your receiving and picking with QuickBooks mobile barcode scanning. . Learn More

Make your picking and packing process faster

Using mobile barcode scanning, managers can effortlessly send orders electronically to pickers and packers on the floor.

More information you can get real-time data

With reliable, real-time inventory data, you can make better business decisions.

What is a QuickBooks Barcode?

Typically printed on a label to identify a QuickBooks inventory item. A barcode is a method of representing part numbers / SKU data in a visual, machine-readable form. Barcodes represent characters of data by varying the widths and spacings of parallel lines. These barcodes, now commonly referred to as linear or one-dimensional, can be scanned by special optical scanners, called barcode readers.

What are barcode readers?

A barcode reader (or barcode scanner) is an optical scanner that can read printed barcodes, decode the data contained in the barcode. These can be directly attached to a hardware device, a rugged handheld scanning device and today smart phones.

What are UPC codes?

UPC codes are also knows as bar codes, but are issued by a central authority for a fee, and are thus unique in all the world.  If you’re not selling through a retail chain, you don’t need them.

Why is a QuickBooks barcode different from a QuickBooks Point of Sale software?

This is where you get into the POS software:  UPC codes must be ‘mapped’ to an internal or external stock number.  The UPC code may be similar, completely different, or nonexistent, for any given SKU.

There’s no mapping system built into QuickBooks.  There’s an internal item ID, a 52-character part code, and a description.  The part code is search-able, but only from the beginning of the code.  The description is searchable on any character.  There a 5, 100 character ‘user’ fields in which you can put any data you like, but you can’t access any of that data from any invoice data entry screen.

Some QuickBooks inventory item numbers may be set up with the UPC, like “123456789 Scooby Doo Lunch Box”, or may have descriptions that contain the UPC, like “Scooby Doo Lunch Box 123456789”.   Once that’s all set up, you can program your bar code reader for the appropriate number of [TAB] entries to get it to the right place on screen.

QuickBooks Scanners

If you use a directly attached scanner you can plug it in to your hardware and scan a few bar codes in the item maintenance window, while adding lines to a sales order or purchase order. Most Barcode “Wedge” scanners do not have to be configured.  They have computer chip in them that decodes just about any barcode they come across.  Some are programmable, so that when you pull the trigger and they pick up a valid bar code, they will send (for example) [enter] [tab] <the ascii text in the barcode> [tab] [tab] to the program being used.

There are many different formats of bar code.  One of the easiest ways to print barcodes, is to use a “3 of 9” font in Windows.  (sometimes called Code 39).  There’s no checksum to calculate and print, all you need to do is put an asterisk (*) character at the beginning and end of the text that you want to encode.  (Obviously, you can’t use the asterisk as part of any barcodes). Requires an asterisk at the beginning and end of the ASCII text.   It’s start / stop codes are easy to add (i.e. in Excel)

Most barcodes have a start / stop code, and / or a Checksum.  The start / stop code is how the bar code reader knows it just saw the whole barcode.  The Checksum is how the reader knows it saw it correctly. Code 39 uses only a start / stop code.   Code 128 uses both.

What is QuickBooks Barcode Code 39?

Code 39 is a variable length, discrete barcode symbology. Code 39 uses characters that are displayed in this example it’s “=Concatenate(“*”,A1,”*”).  The Code 39 specification defines 43 characters, consisting of uppercase letters, numeric digits and a number of special characters. An additional character is used for both start and stop delimiters.

Code 39 is a bit more prone to misreads, since there is no checksum.  (but still less prone to error than manually entering these item ID’s. If you are looking at using Code 39 AND picking up UPC-A codes then the part number will need to be the UPC number unless your scanner can interpret both.

More about Code 39 can be found:   http://en.wikipedia.org/wiki/Code_39.

What is QuickBooks Barcode Code 128?

Code 128 is a high-density linear barcode symbology defined in ISO/IEC 15417:2007. It is used for alphanumeric or numeric-only barcodes. It can encode all 128 characters of ASCII and, by use of an extension symbol, the Latin-1 characters defined in ISO/IEC 8859-1.

Code 128 Requires a ‘Check Digit’ calculation included in the barcode. Also uses encoded start / stop codes that aren’t the same as each other. It is possible to have a scanner use UPC-A codes as long as the inventory item numbers are the UPC-A numbers unless your scanner can interpret both.

More about Code 128 can be found: http://en.wikipedia.org/wiki/Code_128 .

Where do I get more information on fully integrated QuickBooks Barcode Scanner?

Reduce errors, do more and run leaner operations. Incorrect unit counts, mismatched SKUs and improper cutoffs are just a few common inventory errors that cost companies millions in profits every year. Enterprise’s barcode inventory management helps solve this — and it’s mobile!

Advanced Inventory lets you incorporate pre-existing barcodes or it can generate new ones for you. Plus, it’s completely integrated with QuickBooks and automatically fills fields with the correct information when barcodes are scanned.

Streamline your order fulfillment and manage your warehouse processes using a single dashboard. Barcode scanning integrates seamlessly with Enhanced Pick, Pack, and Ship and our new Express Pick-Pack feature, which lets you combine the picking and packing roles to save even more time.

For more information about QuickBooks Scanners for QuickBooks visit www.jcscomputer.com

Or give us a call 800.475.1047. Put our 30 years of QuickBooks experience to work for you.

X