Skip to content
English
  • There are no suggestions because the search field is empty.

How to keep your store's books with Rose Books

Set up Rose Books, book each day's sales, payouts, rent and Square deposits, read receipts with Rosebot, and run your profit & loss and balance sheet.

Rose Books keeps double-entry books for your store from what Rose already knows. Each day's sales come in already split into what you owe consignors and vendors, your commission and fees, and sales tax. Payouts, rent, Square deposits and the receipts Rosebot reads for you come in too, ready to book.

Set up Rose Books

You set up Rose Books once. Every consignor's and vendor's balance comes over from Rose by itself, so you only type in the store's own money.

  1. Open Rose Books in the menu (under SALES & CONSIGNORS). You need the Administration right.
  2. Under YOUR STORE, tick every kind of store that fits you (consignment shop, vendor mall, boutique, gallery, thrift). This sets up your chart of accounts. You can add more later.
  3. Pick BOOKS START ON: the first day Rose Books records. Tomorrow is the earliest. The 1st of next month gives you whole months in your reports.
  4. Type BANK BALANCE: your business checking balance at the end of the day before the start date (your bank's online balance that night, or the statement's closing figure for that day).
  5. Type CASH IN DRAWERS: the cash in all your registers and the safe, counted at closing the night before.
  6. Type SALES TAX OWED: sales tax you have collected but not yet paid to the state. Square shows it under Reports → Sales Taxes, from the 1st of your filing period to the night before. If you just filed, it is close to 0.
  7. Press SET UP ROSE BOOKS.
  • What each contract is owed in Rose on that day becomes their opening balance, so the books start out matching Rose.
  • A figure that turns out wrong can be corrected later with + ENTRY against Opening balances. Nothing has to be perfect on day one.

Get each day's entries from Rose and Square

  1. Press GET FROM ROSE & SQUARE at the top of Rose Books (once a day is enough, for example each morning).
  2. Rose builds one entry for each day's sales at each location, one for each day's Rose activity (payouts, rent and fees, charges, in-store purchases and credits), and one for each new Square deposit, and one for each day's Square tips and service charges.
  3. Each entry waits in TO BOOK until you book it. Nothing counts in your books before that.
  • Each day's sales are split the same way posting a sales batch works out payouts: your PAYOUT RULES, item fees, card fees and the tax on store commission. Card sales go to Square - not yet deposited, cash to Cash drawers, store credit and other payments to their own account. A gift card you sell goes to Gift cards not yet used, and a sale paid with a gift card comes off it.
  • Tips go to Tips owed to staff, and order service charges to Service charges. When you pay the tips out (in cash or with payroll), make a + ENTRY from Tips owed to staff to the account you paid from.
  • If Square took more or less by card on a day than Rose's sales show (for example a refund that wasn't on a returned item), that day's tips entry says so, or GET FROM ROSE & SQUARE lists it. Check it in Square. Rose Books never books a difference just to make it match.
  • Square deposits need Square's payouts permission. If Rose says so, open Administration → SETTINGS → SQUARE and press CONNECT AGAIN. Daily sales work without it.
  • Today's sales come in tomorrow, when the day is finished.
  • If a day you already booked changes in Rose afterwards (for example a sale edited in a sales batch), it shows under BOOKED, CHANGED IN ROSE SINCE. Press VOID on it, then GET FROM ROSE & SQUARE to build it again.

Check and book entries

  1. Open the TO BOOK tab. SHOW starts on WAITING TO BOOK.
  2. Click an entry to see its lines (account, debit, credit, and the account number for a consignor or vendor).
  3. Press BOOK THIS, or BOOK ALL READY at the top to book everything that has no note.
  4. An entry marked NEEDS A LOOK has a note in red (for example a sale on an account that isn't in Rose). Fix it in Rose and build it again, or press BOOK IT ANYWAY.
  • DELETE DRAFT removes an entry that isn't booked. A day from Rose or a Square deposit is built again by the next GET FROM ROSE & SQUARE.
  • VOID takes a booked entry out of your books. It stays in the list marked VOID, so nothing disappears.

Read the Overview

  • CASH IN BANK + DRAWERS: your bank and cash accounts from booked entries.
  • OWED TO CONSIGNORS & VENDORS: what you hold for them. It is their money, kept apart from yours.
  • SQUARE NOT YET DEPOSITED: card sales Square hasn't paid into your bank yet. It should come back to about $0 after each deposit is booked.
  • NET INCOME THIS MONTH: your commission, fees, rent and own sales, less your expenses, compared with the same days last month.
  • SALES TAX PAYABLE: tax collected and not yet paid.
  • WHERE THIS MONTH'S SALES WENT splits the month's booked sales between consignors and vendors, your commission and fees, store-owned items and sales tax. TO DO lists what is waiting.

See what each consignor and vendor is owed

  1. Open the CONSIGNORS & VENDORS tab and pick FROM and TO.
  2. Each row shows their share of sales, rent, fees and charges, credits, what was paid out and what they are owed in the books, next to their balance in Rose now.
  3. Press EXPORT for a spreadsheet.
  • OWED (BOOKS) and OWED (ROSE NOW) can differ while days are waiting to be booked, or for sales not yet posted in a sales batch.
  • PAID THIS YEAR (1099) adds up every payout this year (cash, check, Rose Pay and in-store) to help with your 1099s. Rose Books doesn't store tax ID numbers.

Rent and recurring fees

Rent and recurring fees are set up on each contract in Contracts → BILLING (or on a booth in the Floor Map), as before. Rose charges them to the account, so they come out of the consignor's or vendor's sales before payout.

  • The RENT & FEES tab lists every recurring charge still running, with about how much they bring in a month.
  • Each day's charges come into your books with the Rose activity entry, as Rent & fees charged.

Add a receipt or bill with Rosebot

  1. Press + RECEIPT / BILL.
  2. Press UPLOAD A PICTURE OR PDF and pick the receipt or bill (up to 15 MB).
  3. Rosebot fills in the date, who was paid, what for, the total and the expense account. Check each one.
  4. Pick PAID FROM: your bank, your cash, or Bills to pay for a bill you'll pay later.
  5. Press BOOK IT, or SAVE AS DRAFT to book it later.
  • The file is kept in your File Manager, in the ROSE BOOKS folder.
  • The file is read on Consignor Connect's server.
  • 🔒 Rosebot never sends personally identifiable or sensitive information outside our server. Names, e-mails, phone numbers and addresses are taken out before anything is sent to its AI. We don't keep tax IDs, card numbers or full bank account numbers, and if one is typed into a note or message, Rosebot takes it out too.

Make an entry by hand

  1. Press + ENTRY.
  2. Pick the DATE and type WHAT IT IS.
  3. On each line pick the account and type the debit or the credit. Press + LINE for more lines. For a line on Due to consignors or Due to vendors, type the contract number under Account #.
  4. When it says BALANCED, press BOOK IT (or SAVE AS DRAFT).

Tip: Not sure which side? Money coming into an account you own (bank, cash) is a debit; income and what you owe others are credits. Ask Rosebot on the Overview if you're unsure.

Run your reports

  1. Open the REPORTS tab.
  2. Pick PROFIT & LOSS, PROFIT & LOSS BY LOCATION or BALANCE SHEET.
  3. Pick FROM and TO / AS OF. The report updates straight away.
  4. Press EXPORT for a spreadsheet to send your accountant.
  • Reports use booked entries only.

Your accounts, and closing a month

  1. Open ACCOUNTS & JOURNAL.
  2. Press + ACCOUNT to add an account, or click one to rename it or switch it off. ADD A STORE TYPE'S ACCOUNTS adds a store type's accounts you don't have yet.
  3. To close a month, pick BOOKS CLOSED THROUGH (for example the last day of the month) and press SAVE.
  • Accounts marked ROSE POSTS HERE are the ones Rose books to by itself. You can rename them but not switch them off. No account is ever deleted.
  • Nothing can be booked, changed or voided on or before the closed day. Close a month once your bank statement matches and your accountant is happy.
  • The JOURNAL at the bottom lists the last 300 booked entries; click one to see its lines.

Ask Rosebot about your books

  1. On the OVERVIEW, type your question under ASK ROSEBOT, for example "Which location made the most this month?" or "How much sales tax do I owe?".
  2. Press ASK.
  • Rosebot answers from your booked figures.
  • 🔒 Rosebot never sends personally identifiable or sensitive information outside our server. Names, e-mails, phone numbers and addresses are taken out before anything is sent to its AI. We don't keep tax IDs, card numbers or full bank account numbers, and if one is typed into a note or message, Rosebot takes it out too.
  • For tax rules Rosebot gives the general rule; check the details with your accountant or your state.

Reconcile your bank account

  1. Open the RECONCILE tab.
  2. Pick the ACCOUNT (Checking to start with), then type STATEMENT ENDS ON and STATEMENT ENDING BALANCE from your bank statement. Press START.
  3. Tick ON STATEMENT for every line that is on the statement. The DIFFERENCE updates as you tick.
  4. When the difference is $0.00, press FINISH. Press SAVE FOR LATER to carry on another time.
  • The first reconciliation starts from $0.00 and lists every booked line, the opening balance too. After that each one starts from the last statement's ending balance.
  • FINISH only works at a $0.00 difference. Rose Books never adds an entry to make it match. If something is missing (a bank fee, a deposit), add it with + ENTRY or + RECEIPT / BILL and book it, then press START again.
  • Ticked lines are locked: their entry can't be voided. To change one, press UNDO LAST under PAST RECONCILIATIONS (it is written to AUDIT), then reconcile again.
  • REPORT shows the lines a reconciliation cleared; EXPORT gives your accountant a spreadsheet.
  • CLEAR drops a reconciliation you started but don't want. Nothing in your books changes.

See who did what (AUDIT)

  1. Open the AUDIT tab.
  2. Pick FROM, TO and WHO (or Everyone).
  3. Press EXPORT for a spreadsheet.
  • It lists every booking, void, deleted draft, closed month, reconciliation and account change, with who did it and when.
  • Nothing on the list can be changed or removed.

Upload your bank statement

  1. Download the statement from your bank's website as a CSV, OFX or QFX file (QFX is the Quicken / QuickBooks one).
  2. In Rose Books press + BANK STATEMENT (or the same button on RECONCILE), pick the ACCOUNT and press PICK THE STATEMENT FILE.
  3. The first time a bank's CSV comes in, check WHICH COLUMN IS WHICH and press USE THESE COLUMNS. Rose remembers it for that bank.
  4. Check each line. Pick GOES TO where Rose hasn't, untick anything you don't want, then press ADD TO TO BOOK (or BOOK THEM NOW).
  • ALREADY IN THE BOOKS: Square deposits, payouts and other entries Rose has are found by amount and date and never added twice. The same statement uploaded again adds nothing new.
  • MIGHT BE A DUPLICATE: the same amount within 3 days of an entry (a receipt you added, for example). It stays unticked; tick it only if it is a different payment.
  • TRANSFER between your own accounts goes to Savings, LOAN PAYMENT to Loans (type the interest part to split it), and OWNER DRAW to Owner draws. Change any of them if they're wrong.
  • A single check to a consignor can be inside a day's payouts in the books. If Rose doesn't find it, pick Due to consignors only if it isn't already a Rose payout; otherwise untick it.
  • Tick MAKE A RULE and Rose fills in the same account next time. Press RULES to change them; PREVIEW shows what a rule would have caught. A rule never adds a line by itself.
  • The file is read once and not kept. Account numbers in it are ignored. The Overview reminds you when your last statement is over a month old.

Who can do this (user rights)

Right in User Maintenance What it allows Who has it at first
Administration and Subscription Plans Opens Rose Books and everything in it: set up, book, void, reports, accounts and closing a month. Users with Administration ticked in User Maintenance (normally administrators)

Questions

Does Rose Books replace QuickBooks?

It can. It keeps full double-entry books with a profit & loss and balance sheet, and it already knows how each sale splits between you, your consignors and vendors, and sales tax. Reports export as spreadsheets for your accountant.

Why does a day's sales entry show what I owe consignors as a credit?

Their share of a sale is their money, not yours, so it goes to Due to consignors (or Due to vendors) until you pay them. Your income is your commission, fees, rent and the sales of your own items.

Why is Square not yet deposited not $0?

Square pays card sales into your bank a day or two later. Once each deposit is booked it comes back to about $0. If it keeps growing, press GET FROM ROSE & SQUARE, and check Square's payouts permission (Administration → SETTINGS → SQUARE → CONNECT AGAIN).

I booked a day by mistake. Can I undo it?

Yes. Press VOID on it in TO BOOK (pick DAILY SALES or ROSE ACTIVITY under SHOW), then GET FROM ROSE & SQUARE builds it again. A closed month can't be changed; open it first by clearing BOOKS CLOSED THROUGH.

Do my receipts go to an AI company?

The picture or PDF never leaves Consignor Connect's server. It is read there, and only the text, with names, e-mails, phone numbers, tax IDs, card and account numbers and addresses taken out, goes to Rosebot's AI to fill in the entry.

Can my consignors or vendors see my books?

No. Rose Books is only in Rose, for users with the Administration right.

Still stuck? Ask Rosebot (the bubble at the bottom right of Rose and myPortal) or contact Consignor Connect support.