February 2016 - SQLWorks

Fact Sheet: Purchase Ledger

SQLWorks Purchase Ledger is your main accounting ledger for your ordered items and purchase transactions with other companies.

Purchase Ledger can be found under the ‘Accounts’ heading in the main NavBar (1) and helps manage each stage of the buying process. Any chosen company from your Companies List can be given a purchase Ledger account, and appears in the list panel (2).

In the main window the top panel displays purchasing information relating to that company, including contact details, outstanding invoices and default settings for your purchases from that company, such as a credit limits and nominal codes.

The first ‘All Outstanding’ tab in the lower panel shows a useful summary of your unreconciled payments, customer quotes, outstanding purchase orders and halted items. From left to right tabs headed ‘Orders’, ‘Transactions’ and ‘Unreconciled Items’ (3) allow you to enter each stage of purchasing by clicking on it – keeping a close track on orders placed and received, and money owed.

Unlike your Sales Ledger, items must follow a dual progression to account for both order and invoicing – by logging ‘receive orders’, SQLWorks can support staged deliveries, or other orders that are delivered and invoiced separately by your suppliers.

Users with SQLWorks advanced stock module can track incoming stock items as ‘In Transit’ whilst awaiting delivery, while all users can take account of part orders, expected time of arrival (ETA), and even batch multiple orders as a single ‘delivery.’ ‘Pending Stock’ under your ownership can be allocated, but other SQLWorks functions are restricted to prevent the mis-selling of items not yet physically available for onward dispatch.

Once you have been invoiced, SQLWorks Purchase Ledger allows your business to reconcile multiple orders against a single invoice, flexibly matching your suppliers’ invoicing format. Saved default settings allow SQLWorks to remember other payment conditions for each supplier, such as price rounding and VAT rules, and (with CRM document storage) archive files such as digital copies of supplier invoices.

Payments can be grouped together or processed via BACS, an authorisation system allows larger organisations to set customised purchasing limits for staff, and force users to clear orders past an administrator before being placed. Spending limits can be set by order, outstanding amount, over a chosen time period, or a combination of these for maximum security.

Every reconciled invoice is linked directly by a nominal code to your nominal code category, so SQLWorks always gives an accurate, real-time reflection of your current purchasing finances in your Nominal Ledger.

 

Lineal launches new SQLWorks website

Lineal Software Solutions have launched of our new sqlworks website for our SQLWorks Business Management Software (www.sqlworks.co.uk).

Managing Director of Lineal, Mike Matthews, explained: “This is a big year for SQLWorks, as we’re due to release Version 8 in conjunction with the release of Omnis 8, and we wanted to overhaul our SQLWorks website too.”

“We always aim for our software to work how you work: we’ll now be offering 3 different delivery models to suit different businesses’ needs, with SQLWorks available in on-premise, hosted and cloud versions.”

SQLWorks, Lineal’s leading software for Accounting, CRM & Stock Control was first developed for manufacturing in 1983, and has evolved substantially over 33 years.

Keeping up with the times, the new website has been designed to be fully responsive, for use on mobile and tablet devices. More and more people will use SQLWorks on the move in the future, from a variety of devices, so the SQLWorks website should mirror this.

Existing SQLWorks users will also receive additional support, accessing learning materials via the SQLWorks News page. Extra features, including a live SQLWorks demo and our SQLWorks help guide, will be available soon – watch this space!

 

Discover SQLWorks today: visit www.sqlworks.co.uk or call 01271 375999

Fact Sheet: Sales Ledger

fact sheet sales ledger

SQLWorks Sales Ledger is your main accounting ledger for your quotes, orders, refunds and sales transactions with other companies.

Sales Ledger can be opened under the ‘Accounts’ heading in the main NavBar (1) and includes a full suite of accounting tools. Any company from your Companies List can be given a Sales Ledger account – appearing in the Sales Ledger List (2) for further use.

From here you can prepare quotes, log orders and more, before sending out any invoices and receiving payments from a given company. As you complete sales, your sales move from left to right – starting as disbursements, leads or quotes, becoming orders, and then transactions. The Sales Ledger information for a company is displayed in the Main Window, with ‘Quotes’, ‘Orders’, ‘Transactions’ and more available by clicking the Tabs on the lower right panel (3).

SQLWorks allows you to keep a close track of money owed, customer debts and credit: you can set a Credit Limit for each business along with precise payment terms, deadlines, known company directors, and instruct SQLWorks to email or print invoices as needed. Any custom settings for a given company also allows you to customise SQLWorks reports to reflect this.

Track aged debt with payment terms, turnover, profit, balance history, debt days, stock items bought and other enquiries, all from the account activity section of any given company in your Sales Ledger. If you need to transfer data, electronic data interchange (EDI), allows a user to export orders, or import invoices from other digital sources.

The SQLWorks team can also configure your Sales Ledger to more closely match your sales – adding automatic adjustments for discovered stock, setting up cash account sales or more uncommon types of invoices if needed.

Every financial entry (invoice, receipt or credit note) is linked directly by a nominal code category to your nominal code category, so SQLWorks always gives an accurate, real-time reflection of your current sales finances in your Nominal Ledger.

 

Contact us today about accounting with SQLWorks: 01271 375999 or www.sqlworks.co.uk/contact-us

Did you Know? Global Search

Sometimes you just need to be able to search all of SQLWorks at once – so SQLWorks’ Global Search function has been built to allow users to easily search anywhere (or everywhere) for that elusive file, record or entry.

Pressing the keyboard shortcut ‘Ctrl G’ (or ‘Cmd G’ on Apple devices) opens the Global Search window (1), from which users can select sections of SQLWorks they want to search through using the checkboxes in the top left (2) (e.g.: ’CRM’, ‘Stock’ etc, or simply ‘All’).

Type the intended search term in the text field, and specify the terms of the search: ‘Begins With’ the search term or ‘Contains’ the search term, using the radio buttons, and click the magnifying glass or press return to begin the global search (3).

Global Search will list any and all results in the List Menu below, including where those entries were located. As always, right clicking a list option and click ‘Get Info’ to see more information about that entry.

Double clicking a list item opens that entry from the relevant part of SQLWorks, wherever it has been found.

 

For more information, contact our team today: 01271 375999