SERVICES ...................................

QDOBA EXPORT FROM QDOBANET for QUICKBOOKS
BUSINESS CREDIT CARD IMPORT for QUICKBOOKS

This Visual FoxPro Utility created by AliMac PC Services takes standard reports from Qdobanet or Menulink and creates QuickBooks import files for most General Journal Items in seconds.

Daily Sales Reports:

We can take the Cash Reconciliation Weekly SheetView report and within seconds create a general journal file for QuickBooks. This can be imported as one file for the week or one for each day of the week.

Inventory:

We take the last Inventory Extension Summary report of the period and create a QuickBooks import file that credits Pork, Meat, Chicken, Dairy, Produce, Tortilla, Liquor, Beverage, Dry Goods, Products in Process, Paper and Plastic, Cleaning Supplies and Restaurant Supplies and balances against a balance sheet account.

Invoices, Paid Outs and Transfers:

We take the report from Purchasing - Cost Journal for Accounts Payable which has three components. Invoices, Paid outs and Transfers between stores and create import files for QuickBooks.

Paid Outs
In the sales import we classify paid outs as a Miscellaneous expense. By using the cost journal we credit back miscellaneous expense and debit the correct cost account.

Transfers
We take the Seller transfers transaction from the AP Cost Journal and make an import file that credits and debits the correct stores. We do not use the Buyer transactions from the Cost Journal for the import file as we use an equivalent negative Seller record to balance. To keep the system honest though we do create a DO NOT MATCH REPORT to show where the stores do not match as sellers and buyers. If the Invoice #, Invoice Date, Amount, Account or store do not match we flag in the report.

Invoices
We create the following screen based on the invoices as entered in the cost journal. The accounting staff just approve what manager entered, match up correct vendor and then create the import file. Invoices can be deleted or changed. We also do a check to see if the invoice already exists.

When you import the file it sits in accounts payable waiting to be paid.
We use a third party ODBC driver (extra cost) that interfaces directly with QuickBooks so we have real time info on vendors and invoices paid.

Qdobanet Financials Vs QuickBooks:

If you have our internet based Statements and Transactions Reports on your website we can add a new report called Qdobanet VS Actual. This can viewed by store managers and management (with permission) to see where their Store Menulink financials differ from the real financials. We just show the accounts on the report that exist in Qdobanet so that it shows a true picture.

Credit Card Import Into Quickbooks:

Most banks let you download your Credit Card Statements in Excel or CSV format. You can separate by user and then code them to the account and store. The columns are Transaction Date, Posting Date, Description, Account # and Class. We can create import files for QuickBooks that balance against expenses and the credit card BS account. Even if your credit cards straddle across months we automatically separate and get them in the correct month. After the import you can still reconcile your statements as normal.

We are currently working on importing Merchant credit card and bank deposit info.