SuperManager Adds Support for Printing Amazon Postage

SuperManager has long supported downloading Amazon orders and allowing store owners to email customers, print reports, print shipping labels, mark orders fulfilled, export them to QuickBooks and perform many other order processing functions. With version 1.8.5.0 store owners can now print Amazon shipping labels. This allows store owners to take advantage of Amazon preferred pricing and directly have orders marked as fulfilled when the labels are printed.

All store owners need to do is click “Get New Orders” to pull them into SuperManager, then select the ones that are ready for shipment, right click and choose “XML Exchange”, “Amazon Shipments”. SuperManager takes care of the rest.

If you already SuperManager, just choose “Help”, “Check for Updates” to update to the new release. If you don’t already have SuperManager, request your free 30-day, no strings attached trial here.

Start printing your Amazon shipping labels through SuperManager today and save time and money!

Posted in Uncategorized | Leave a comment

SuperManager Adds Support for SparkPay Stores

Need help managing your SparkPay store? Have you been migrated from Americart to SparkPay? SuperManager is now able to help you! With the release of version 1.8.5.0, SuperManager adds support for automatically downloading orders from your SparkPay store. After downloading your orders, you can use SuperManager to:

  • Manage — Automatically verify addresses against USPS databases, Send dropship requests to suppliers, Check orders against inventory and highlight backorders, Highlight orders that fail your fraud screening criteria, Capture authorized transactions in batch through Authorize.net or PayPal, Send emails in batch to customers using customizable templates
  • Print — Print customizable receipts, packing slips, pick lists and other reports, Print shipping labels for USPS, UPS or FedEx
  • Export — Export orders or merchant batches to QuickBooks or QuickBooks POS, Export order information for data mining or integration with other software
  • And much more…
  • If you don’t already have SuperManager, request your free 30-day, no strings attached trial here.

Posted in SuperManager Developments | Leave a comment

Need to Easily Import POs or Bills Into QuickBooks?

SuperManager has long been a convenient, flexible solution for exporting your Aabaco, Amazon, Shopify, BigCommerce and other online store orders into QuickBooks. With the release of version 1.8.1.0, SuperManager now also supports importing your POs and Bills into QuickBooks. SuperManager can import POs into its internal database using a custom defined text import format. Using this functionality you can import bills from your suppliers received in spreadsheets or other text reports. Then, you can export those POs into QuickBooks using SuperManager’s highly configurable interface.

If you don’t already have SuperManager, but have need to export your POs automatically into QuickBooks, you can request your free trial here.

Posted in QuickBooks | Leave a comment

Exporting Your Amazon Store Orders to QuickBooks

Owners of Amazon and other eCommerce stores are often overwhelmed by the prospect of keeping track of their accounting. Accounting information is not only important for keeping track of your profit and loss and inventory, but will save you headaches, time and money when it is time to file your taxes. If all of your sales are documented you can easily pull up a profit and loss statement and other information you will need for filing your taxes. QuickBooks is the industry standard for small business accounting, according to Intuit, the makers of QuickBooks, it is used by 85% of small businesses. Using information you can readily export from Amazon and third part software like The SuperManager you can keep track of your Amazon store sales in QuickBooks with limited touch time, allowing you to focus on building your business, minimize headaches of doing your own accounting and expenses for bookkeeping and accounting services.

Deciding What Information You Need
Before getting into the mechanics of exporting, let’s talk about what you need to keep track of.

  • At a bare minimum you will need to keep track of your profits and losses. This includes revenues from sales and shipping income, sales taxes collected and fees assessed by Amazon
  • You may want to use QuickBooks to track your inventory. Many businesses use several sales channels: Amazon, Shopify, BigCommerce, WooCommerce and others. You may want to use QuickBooks as a way to combine the impact of all those channels on your inventory
  • You may want to use QuickBooks to have detailed order information including addresses, payment and perhaps even shipment information
  • You may want to use QuickBooks to store your customer database

The manner that you track your orders will depend on which of these options you need.

Profit and Loss
Tracking profit and loss from your Amazon orders can be fairly straightforward. Every two weeks Amazon settles accounts with sellers. As a part of this process they create a settlement report. You can view these reports in seller central by clicking on “Reports”, then “Payments” from the dropdown. Once there, choose “All Statements” from the tabs. This will show a list of all the settlement periods and give you a chance to view each report or download it as a flat comma separated value file.

The summary likely gives you enough information to input your profit and loss line items into QuickBooks. Product sales, shipping fees collected and other income are itemized. Amazon’s fees and other expenses are also itemized. You can replicate this information on a sales receipt in QuickBooks creating one line item on the sales receipt for each of these lines.

If you ever have a settlement period where you pay more to Amazon than you collect in sales, you will need to document the settlement on a credit memo rather than on a sales receipt.

Inventory
In addition to using a single sales receipt for tracking the profit and loss, you can also use it to track inventory. To do this, rather than having one line item for all product charges/income, you will create a list of line items representing all the individual products sold. You can do this by downloading the flat file for the settlement, which will include a line item for each product sold. Take note when doing this that each product sold typically has multiple lines on the report: one for product sales income, one for shipping income, one for taxes collected, one for Amazon fees deducted, one for Amazon FBA charges deducted and perhaps others. You may want to create a line item for each product sale income referencing the QuickBooks item name, but then sum up all the shipping income, Amazon fees and other service items and just have one line item for each of them.

When you try doing this, especially if you have high sales volume, you will quickly find that this can be fairly time consuming. You could likely use some spreadsheet work to make this a bit more palatable. For example, you could build a pivot table of the Amazon flat file. As an alternative, SuperManager can import the Amazon settlement file for you. If you don’t already own SuperManager, you can request a free trial here. Once you have SuperManager installed, here is how you would import a settlement to QuickBooks:

  • Open SuperManager and choose “View”, “Store Settings” and click “Add” to add a store to import your orders into. Enter a name for the store and any other information, although all the other fields are optional for using in this case. Set the store type to “Amazon”. Then press “Ok” to save and close the store settings.
  • Press ctrl-S to save these store settings to your hard drive. You can save the file with any file name and in any location. We recommend saving it under the “SuperManager” folder that is created in your Documents folder when SuperManager is installed.
  • Then to import your first settlement, download it from seller central and save it somewhere on your hard drive. Choose “File”, “Import”, “Orders”, “Amazon Settlement” and select the file from where you saved it.
  • This should result in the settlement being shown in SuperManager as a single order. You can double click on it and look at how the order has been imported.
  • Before exporting to QuickBooks the first time, you will need to go back to “View”, “Store Settings” and select the “Accounting Export” tab. You can read the meaning of each of these export options in the SuperManager user’s manual. Once you have finished setting all the export options, press “Ok” to save and close the store settings.
  • You can now select the order/settlement to export and right click on it and choose “XML Exchange”, “QuickBooks” or press alt-Q, which is the keyboard shortcut.

Detailed Order Information
Rather than batching together all information from each settlement, you may want to have all orders with all their details in QuickBooks. This may especially be the case if you have a lot of repeat customers and want to keep track of them. You can do this manually, however, that will be quite a chore. Fortunately SuperManager can also do this for you. For using SuperManager in this manner, please see the user’s manual, as it will walk you through the setup for exporting individual orders. Again, if you don’t already own SuperManager, you can request a free trial here.

There are many ways to keep track of your Amazon store orders. Depending on how much information you desire to have this can be quite simple or very difficult to do manually. Fortunately, SuperManager can help you do this in one of a couple different ways depending on your needs and wants.

Posted in QuickBooks | Leave a comment

SuperManager Allows Highly Flexible, Highly Configurable Export of Online Store Orders to QuickBooks

One of SuperManager’s key aims is to allow the user a high amount of flexibility and configurability when exporting your Aabaco, Amazon, Shopify, BigCommerce and other online store orders to QuickBooks. The release of version 1.8.0.0 steps that up a bit.

SuperManager allows you to have more than one store/sales channel stored in the same database file. You can now add custom fields associated with each store in the file and then access those custom fields for SuperManager to use as your line item class, transaction class, account names (such as deposit-to account, accounts receivable account, COGS account, etc…) or standard item names (such as shipping, taxes, discounts, etc…). This allows you to export all orders for the stores/sales channels you having using one set of export settings, but with specificity for each of those channels so you can have reporting in QuickBooks separated out for each of those channels. If there is something you are not certain how to do or something else you would like to see, let us know!

If you don’t already own SuperManager, you can request a free trial here.

Posted in QuickBooks, SuperManager Developments | Leave a comment

SuperManager Updated to Interact with Luminate Stores

Yahoo! Store owners have been nervously waiting for the day when the transition to Aabaco Small Business occurred. Like it or not, that day came in mid November 2015. As can be expected, there were a few adjustments to be made to integrating software.

Within a few hours of the Luminate go-live, SuperManager was updated to accommodate the changes. This update was carried on in beta form for a few weeks to make sure additional changes would not be necessary. The updates include modifications to the login sequence, adjustments to API connections and accommodations for inputs that were moved on the pages used for updating order changes back to Luminate.

If you are having problems getting SuperManager to interact with your Luminate store, make sure you have version 1.7.9.0 or later installed. If you still have problems, let us know; we’re here to help!

Posted in SuperManager Developments, Yahoo! Store and Merchant Solutions | Leave a comment

SuperManager Adds Support for Printing Postage through VIP Parcel

With the release of SuperManager 1.7.8.0, we are very happy to introduce our new integration with VIP Parcel. VIP Parcel is a new partner who offers the ability to print USPS postage labels directly within SuperManager.

Their service, unlike others, requires no monthly fee. Additionally, they offer reduced commercial rates.

Give them a try! Simply sign up for an account at http://vipparcel.com/ using source code SXW7. Fund your account using a credit or debit card. In SuperManager, you’ll need to go to the store settings and click on the ‘Custom Fields’ tab and map your ship methods and package types for the ‘XML Exchange – VIP Parcel’ export. Then you’ll need to open the program settings and select the printer you want to use for printing the labels. Most labels are printed onto 4″ x 6″ labels. After doing that, get your first package ready, right click and choose ‘XML Exchange’, ‘VIP Parcel’ or use the keyboard shortcut alt-V. SuperManager will automatically walk you through a simple authentication process and you’ll be printing postage in no time.

Posted in Uncategorized | Leave a comment

SuperManager Adds Support for USA ePay

SuperManager supports several payment gateways. With the release of version 1.7.3.0, we are happy to announce the addition of USA ePay support.

Once you have downloaded orders from BigCommerce, PrestaShop or another platform that integrates with USA ePay, you may have an account listed. If not, you can create one by clicking in the white space on that page and choosing “Add Account”
authorize_net1

Once you add an account – or if you already have one, double click on it – and add the necessary information. Set the type to USA ePay. Then enter your USA ePay API credentials, which you can find in your USA ePay back end

Now that you have the USA ePay credentials entered all you have to do to take advantage of this feature is download your orders as usual from your web store, right click on those that are ready to charge and choose “charge”. You can also authorize and void charges, issue credits and void credits on the order details screen.

We hope you find this new feature useful!

Posted in SuperManager Developments | Leave a comment

SuperManager Adds Support for Volusion and WooCommerce Stores

Need help managing your Volusion or Woo Commerce store? SuperManager is now able to help you! With the release of version 1.7.3.0, SuperManager adds support for automatically downloading orders from your Volusion or Woo Commerce store. After downloading your orders, you can use SuperManager to:

  • Manage — Automatically verify addresses against USPS databases, Send dropship requests to suppliers, Check orders against inventory and highlight backorders, Highlight orders that fail your fraud screening criteria, Capture authorized transactions in batch through Authorize.net or PayPal, Send emails in batch to customers using customizable templates
  • Print — Print customizable receipts, packing slips, pick lists and other reports, Print shipping labels for USPS, UPS or FedEx
  • Export — Export orders or merchant batches to QuickBooks or QuickBooks POS, Export order information for data mining or integration with other software
  • And much more…
  • If you don’t already have SuperManager, request your free 30-day, no strings attached trial here.

Posted in SuperManager Developments | Leave a comment

SuperManager Updated to Allow Several New Features for Exporting Online Orders to QuickBooks

SuperManager 1.7.1.0 has been released and along with it, several new options for exporting orders to QuickBooks:

New Modes of Creating/Updating Customers
SuperManager has always offered the ability to turn on or off the creation of customers with order exports. If you choose to export customers, new customers are created in your QuickBooks file and customer contact information and other data are populated in them. If you choose not to create customers, SuperManager still creates customers when needed based on your customized customer name specification, but it does not populate the contact information and other data. This latter mode is useful for when you want customers only as placeholders in QuickBooks. For example, to save room on the customer list, some store owners just use a single generic name or the order date or some other generic or semi-generic customer reference.

It was also previously possible to specify whether SuperManager should update that customer data when a customer by the same name already existed. No matter what address exists in the customer list, SuperManager always creates new orders in QuickBooks with the address information contained in the order. However, using this option, it also made sure your customer list was up to date with the latest address a customer used on their order.

With the release of version 1.7.1.0 a new mode is available for creating/updating customers. You can now choose the “prompt” option to have SuperManager check if a customer already exists by the name of the current order. If so, it brings up a pop-up window letting you know that a customer by that name already exists. Address information is shown for the existing customer and the new customer. You can press “Ok” to use that customer or enter a new name for the customer of the current order. This gives the user complete control over when a customer should be used from the existing customer list or created new with a custom name.

Additional Data Fields can be Exported
SuperManager has always allowed a great deal of flexibility with allowing you to specify what data to put in which fields. You can use order data using placeholder “field variables” that SuperManager substitutes with actual order data. For example, put the keyword “bill_name” and it places the billing address name. This data can be put in such fields as “ship via” and the “memo” field. Now SuperManager also supports populating the QuickBooks “customer message” and “other” fields with order data using that same approach.

Support for Price Lists
SuperManager has always allowed the use of item groups in the place of standard inventoried or non-inventoried items mapped to products in your online store. This was helpful when you have a group of items that you sell online as a single sku/product in your shopping cart. For example, perhaps you have a product on your store that equates to buying to of a particular item. You can create an item group in QuickBooks and link it to that product so when a customer orders it online, it pulls two of the inventoried item out of your QuickBooks inventory.

SuperManager also has long supported the ability of adjusting the price of an item group to the price the online customer actually paid. In the example above, if you sell the group of two items for less than twice the price of a single one, SuperManager adds a price adjustment to get the order totals to be consistent. New in release 1.7.1.0 is the ability to get that price adjustment correct even when you use a QuickBooks price level list to define the price of those items. Previously SuperManager wouldn’t check the price level list for item groups so this adjustment wasn’t properly calculated. Now, however, this combination is fully supported.

Additional Cosmetic Preferences Now Available
In addition to these, a few preferences were added to adjust the way QuickBooks transactions are created to your liking:

  • Turn on or off the addition of a subtotal. Previously this was always done. Now you can choose
  • Suppress or show the country even when it matches the default country in your program settings. Previously the country always showed in the addresses for your transactions.
  • Customize the ways your ship methods show up. Previously they were always exported as the exact way they show up in your shopping cart. Now you can customize them to be more discernible to your customers and/or just prettier to you.
  • More options are now supported for how to assign the tax reference item

We hope that users enjoy these new options! If you have any other developments you would like to see, please drop us a line. We love getting feedback. At SuperWare, we see development not as just adding functions or features, but as solving the problems that make it harder or take longer to process your orders. Let us know what your problems are. We’re here to solve them!

Posted in QuickBooks, SuperManager Developments | Leave a comment