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!

New in Sage 50 and Sage 50c – U.S. 2018.1 – 800.475.1047 – Support – Training – Consultant – Reseller

New in Sage 50 and Sage 50c – U.S. 2018.1 – 800.475.1047 – Support – Training – Consultant – Reseller

The new features provide flexibility to keep your office connected to the cloud! Features include:

  • New Cloud & Mobile Navigation Center
  • New Sage Bank Feeds Auto-Reconciliation Features
  • Improvements to Sage Contact
  • New Sage Dashboard Office 365 app

Cloud and Mobile Navigation Center

The Cloud and Mobile Navigation Center connects services via the cloud and allows for remote company data sharing. Accessible from the file menu, Office 365, Sage Drive and Sage One are all integrated. Beginning with the release of Sage 50c, the Cloud and Mobile navigation center are included. Your data is securely shared through the cloud without compromising data security. There are many features included with this new navigation center.

Sage Bank Feeds – Auto-Reconciliation Feature

Sage now offers the ability to link your bank account to sync bank and credit card transactions in order to streamline the process of reconciling these accounts. This feature helps eliminate errors with manual data entry while promoting accuracy to match transactions processed by your bank or credit card. The setup is easy through the account reconciliation window. Capture up to 2 years of historical bank records. Once the bank feeds are downloaded, Sage 50c will automatically match the transactions previously recorded to clear.

Sage Contact Improvements

Again, this feature is integrated with Microsoft Office 365 to allow you to view the detailed information about Sage 50c customer and vendor contacts in the Office 365 Mail app and desktop version of Outlook. There is a comms tab that provides the view of previous communication with vendors/customers to easily review history of communications and there is a notes tab to track communications and share notes with other users.

Sage Dashboard – Office 365 App

This is a new application offered in Sage 50/50c that integrates with Microsoft 365 that will allow you to view Revenue-Expense information, Aged Payables and Aged Receivables directly in Office 365. As long as you have access to the web, you will be able to view these features through a series of interactive charts and graphs. This feature provides you the ability to view critical data anywhere, anytime. The app will sync automatically. Examples of these features include Overdue Sales by Period shown on a bar graph for the last 12 months with the ability to drill down on a particular month. An Accounts Aging Pie chart is also available displaying the largest and oldest accounts as the larger pieces of the pie and the smaller piece listed as other with the remaining past due customer accounts. The pie chart can also be drilled down on by selecting a customer. On the Payables tab, the bar graph will display Overdue Purchases by Period and the Pie chart displays Accounts Over 90 days past due. The final tab is Revenue and Expenses displayed for the past 12 months in bar graphs.

For more information on Sage 50 and Sage 50c, 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

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

Accounting Business Solutions by JCS Nominated for 2017 Entrepreneurial Excellence Awards – 800.475.1047 – Support – Training – Consultant – Reseller

Accounting Business Solutions by JCS Nominated for 2017 Entrepreneurial Excellence Awards 

FOR IMMEDIATE RELEASE
Lauren LaMantia
800.475.1047

Arlington Heights, IL September 2017– Accounting Business Solutions by JCS the nation’s leading premier provider of technical support and training for Sage Software, Intuit QuickBooks, MiSys, JobOps, Point of Sale, Timeslips, Advanced Reporting and Barcoding announced their nomination for 2017 Entrepreneurial Excellence Awards presented by Business Ledger. The Entrepreneurial Excellence Award recognizes and builds entrepreneurship in suburban Cook County, DuPage County, Kane County, Lake County, McHenry County and Will County Illinois.

“Accounting Business Solutions by JCS always strives to provide highest quality training and support to its customers”, said Jennifer O’Brien, President, Accounting Business Solutions by JCS “Our commitment to growth for our clients is what really sets us apart”.

About Accounting Business Solutions by JCS

Accounting Business Solutions by JCS provides software technical support and training for Sage Software products including Sage 50 (formerly Peachtree), Sage 100 (formerly MAS 90/200), Sage 100 Advanced, ACT!, Timeslips, and Intuit QuickBooks. In addition, JCS specializes in integration between accounting applications and 3rd party add-ons including e-commerce shopping carts, point of sale and barcode systems and customer relationship management applications. Accounting Business Solutions by JCS provides installation, training – online, your site or our training center, technical support, online, on-site or by phone.

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

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

Sage Fixed Assets Premier – WINFAS Admin Changes – 800.475.1047 – Support – Consultant – Training – Reseller

Sage Fixed Assets Premier – WINFAS Admin Changes – 800.475.1047 – Support – Consultant – Training – Reselle

Sage Fixed Assets 2018.0 includes a security update to the Premier product line as well as a new Android mobile scanner app.

For partners that currently access Sage Fixed Assets Premier’s data using WINFAS administrator password should contact Sage Fixed Assets Support for information regarding the new change. This change only affects the Premier product and does not affect Guest Read-Only access (WINFASGUEST). There will be no impact to existing reporting capabilities. Partners that are currently accessing Sage Fixed Assets Premier’s database using the WINFAS administrator password should notice the security update. It is recommended partners contact Sage Fixed Assets support for more information or contact JCS at 800.475.1047.

All Sage Fixed Assets Premier customers benefit from the enhanced database security except customers and anyone accessing the asset database using the read-only access (WINFASGUEST).

For more information on Sage Fixed Assets Premier 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

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

Sage 50 Sage 100 QuickBooks – Accounting Business Solutions by JCS Expands adding a new office in Charleston, South Carolina 800.475.1047 – Support – Training – Consultant – Reseller

Sage 50, QuickBooks Sage 100 Expands to Charleston, South Carolina

FOR IMMEDIATE RELEASE
Lauren LaMantia
800.475.1047

Charleston, South Carolina  – Accounting Business Solutions by JCS the nation’s leading premier provider of technical support and training for Sage Software, Intuit QuickBooks, MiSys, JobOps, Point of Sale, Timeslips, Advanced Reporting and Bar coding announced the addition of a new office in Charleston, South Carolina. A drastic increase in demand for the company’s training and services to the small-medium business market necessitated the addition of the new office.

“Accounting Business Solutions by JCS always strives to provide highest quality training and support to its customers”, said Jennifer O’Brien, President, Accounting Business Solutions by JCS “Our new Facility in Charleston, South Carolina will provide expanded consulting services to our South Carolina based clients”.

About Accounting Business Solutions by JCS

Accounting Business Solutions by JCS provides software technical support and training for Sage Software products including Sage 50 (formerly Peachtree), Sage 100 (formerly MAS 90/200), Sage 100 Advanced, ACT!, Timeslips, and Intuit QuickBooks. In addition, JCS specializes in integration between accounting applications and 3rd party add-ons including e-commerce shopping carts, point of sale and barcode systems and customer relationship management applications. Accounting Business Solutions by JCS provides installation, training – online, your site or our training center, technical support, online, on-site or by phone.

QuickBooks Sage 50 and Sage 100 Charleston. 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

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

2018.0 – Sage 50c Exclusive Office 365 Release Features – 800.475.1047 – Training – Support – Consultant – Reseller

2018.0 – Sage 50c Exclusive Office 365 Release Features – 800.475.1047 – Training – Support – Consultant – Reseller

Sage Intelligence Reporting with Office 365:

SI Reporting reveals the power of Sage 50c data into Excel. Customize and build powerful report using simple drag and drop design. Now with the ability to publish financial reports to the cloud and access them on your device to provide a deeper understanding to your business insights.

Sage Capture with Office 365:

Capture a receipt or record a transaction then post it to Sage 50c using any mobile device or tablet. Images are stored automatically in OneDrive so you won’t lost a document or receipt again. The Sage Capture App can be downloaded for free from the Apple and Android App stores!

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

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

2018.0 – Sage 50c Release Features – July 2017 – 800.475.1047 – Support – Consultant – Training – Reseller

2018.0 – Sage 50c Release Features – July 2017 – 800.475.1047 – Support – Consultant – Training – Reseller

User Interface Modernization

Sage 50 is calling this a Facelift which has been long overdue. They have updated the Navigation Centers to ease use while keeping the functionality that we all know.

Sage 50c and Traditional:

AP Automaton provided by Beanworks

Beanworks offers a cloud-based accounts payable automation solution that helps companies streamline their invoice to payment process. Invoice routing is automatic and provides the ability to review and approve online. Also pay invoices via automated check, wire, EFT/ACH or virtual credit card.

This feature add-on and partnership will be available to Sage 50, Sage 100 and Sage 300 customers. Sage 50 Quantum customers with 25 or more users will get an immense amount of satisfaction and see increased productivity using the AP Automation.

For more information on Sage 100 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

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

 

2017.1 Features in Sage 50 and Sage 50c – 800.475.1047 – Reseller – Consultant – Training – Support

2017.1 Features in Sage 50 and Sage 50c – 800.475.1047 – Reseller – Consultant – Training – Support

sage-1sage

Four Main Features for Sage 50c

  • Integrates with Microsoft Office 365
  • Mobile and Online invoicing and payments
  • Sage Drive read only access
  • Automatic cloud backup using Microsoft 365

Features available for all versions of Sage 50 and Sage 50c

  • Web mail support
  • Automatic activation of Sage Payroll accounts

Sage 50c Exclusive Online Invoicing and Payments

Customers with Sage 50c are now able to create and send invoices online using computers or the mobile application.  Recipients can use the Pay Now link on the invoice to pay directly and easily online. This feature will help simplify the billing process and shorten the payment cycle.

  • Sage 50c customer records and general ledger accounts are uploaded to Sage One, however no service items, sales tax codes or inventory is uploaded
  • Sage One is available for Sage 50c customers for free. Activation codes are emailed to all customers on November 16, 2016. New customers will receive the activation code when purchased or upgraded to Sage 50c.
  • Sage 50c customers can now download open invoices into Sage 50c from Sage One
  • Paid invoices, Sage 50c customers must manually record receipts into Sage 50c
  • Once Sage 50c customers create a Sage Once account, entry of inventory and service items must be manually entered. Then the ability to generate and send online invoices from Sage One is available using either their computer or the mobile app
  • Pay Now link is available for recipients/payee using PayPal from emailed invoices. For customers that have SPS Merchant account can choose the option to receive a credit or debit card payment
  • Sage One Accounting offers Online Invoicing and Payment ***

*** Online and mobile invoicing requires a Sage One subscription for integration. This is a one way integration and will require users to manually enter their inventory and service items into Sage One; customer records and general ledger accounts will be entered for them. Only customers on the latest release of Sage 50c Accounting have access to the Sage One integration. If customer cancels the Sage One integration service, to maintain access to Sage One, customer must set up separate billing. Not all Sage One features are available on the mobile app. Mobile devices sold separately and require a data plan. Data access is subject to cellular provider network availability and occasional downtime due to system maintenance.

Sag 50c Exclusive Microsoft Office 365 Integration

Staged releases for Sage 50c customers in the U.S., Canada and the UK will provide features integrated with Microsoft Office 465.

Microsoft Office 365 automatic cloud backup* (c-line exclusive)

This feature provides Sage 50c customers the ability to store and retrieve company backup files online securely through the Office 365 integration.  This feature was ranked Number 1 in recent survey of new features.

* Requires Microsoft Office 365 Business Premium license, available through Microsoft.

Sage 50c Exclusive Read-Only Mode

This allows additional Sage 50c users to access the shared company in a read-only mode while active users has the ability to still work in the company file.

Web mail support – Available to both Sage 50 and Sage 50c Customers

Customers can now utilize their web-based email services (e.g., Gmail, Yahoo, Hotmail, Live, AOL, and Office 365, etc.) when emailing transaction forms such as invoices or receipts from Sage 50.

Automated Sage Payroll In-Product Activation – Available to both Sage 50 and Sage 50c Customers

Sage Payroll Services customers will now have automatic in-product activation of their payroll account. This improves and automates the current manual process that requires the Sage sales colleague to generate an activation code and email it to the customer who must then enter it into Sage 50. Now Sage Payroll customers identify themselves in product and the activation code is entered for them.

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

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

Sage 50 – Questions for your Network Server – 800.475.1047 – Support – Training – Consultant – Reseller

Sage 50 – Questions for your Network Server – 800.475.1047 – Support – Training – Consultant – Reseller

While this list can be extensive, it is extremely important to have more information to purchase, upgrade, or update your Network Server adequately to meet your businesses current needs and future needs.

  1. Do you have a current server?
  2. Is the new server replacing your current server or is it in addition to your current server dedicated to Sage 50?
  3. What are the specifications of your current server?
    1. CPU –
    2. Memory –
    3. Disc Space (total and available) –
    4. Backup Technology currently in place –
  4. Are the workstations members of the domain or running as peer-to-peer?
  5. Is the server running Active Directory Domain Services or acting as a Member Server?
  6. What services are currently configured on the server?
    1. Examples: DNS, SHCP, File Sharing, Network Printing, Terminal Services, Email, etc.
  7. Are you using any network-accessible or network-wide applications?
    1. Example: Server-managed anti-virus software to monitor connected workstations
  8. How many workstations are on the network, potentially accessing resources of the server?
    1. Example: Access to shared folders, network printing services, managed anti-virus software, etc.
  9. How many users are on the network?
    1. This could be differ depending on multi-user PC’s, multiple shifts, etc.
  10. What backup technology are you using?
    1. Examples: Removable hard drive, tape/cartridge, cloud solution, etc.
  11. What is your backup schedule and policy?
    1. Examples: Every night, once a week, full or incremental backups, month-end archives, etc.

Questions related to your networking environment that may or may not have impact on your server

  1. Who is your internet server provider?
  2. What are you upload/download speeds?
  3. What equipment and/or technology are you using for perimeter security?
    1. Examples: Firewall, routers, etc.
    2. Cisco, Sonicwall, ISP-Provided, etc.
  4. What equipment do you use for your network topology?
    1. Examples: switches, print servers, wireless access, etc.
    2. Are they Switch(es) 100mbps or Gigabit speed?
  5. Do you have any peer-to-peer networking or only client-server?
    1. Examples: Peer-to-Peer – engineering can access secretary’s hard drive or printer. Client-Server – only device providing resources is the server

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

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