Used bookstore buy-back/trade-in

I am a bookkeeper and I have a new client, a used bookstore, that is also a new business. They accept buy-backs/trade-ins for store credit, and I'm trying to wrap my head around how the accounting works for this, and how best to set it up in her POS (Square). It looks like she is issuing gift cards, but that does not seem quite right to me. (I just emailed the client to ask about her buy-back workflow.) Can someone walk me through how to set this up in QBO and how it should be treated in a POS?

reddit.com
u/21stcenturycoolgirl — 8 days ago

Question about the QuickBooks/Square integration

I am a bookkeeper, I have a new client who uses Square POS. I just set up the integration using the native QBO connector. I have a question about card transactions I am seeing in QBO. It doesn't match the UI of the videos, but possibly they have made updates and the videos are outdated.

When you go to Integration Transactions > Square > For Review, do you see individual Card Transactions in the feed? Or do you have to click on a Payout and look at Included Transactions?

reddit.com
u/21stcenturycoolgirl — 14 days ago

QBO subscription with Square

I am a bookkeeper and I have a new client using Square. I don't plan on tracking inventory in QBO since it's tracked in Square. My understanding is that we will have a default inventory item in QBO.

Given that, does anyone know if we can use the Simple Start plan? It doesn't include inventory tracking, but given that we aren't going to actually track inventory in QBO, it seems silly to have to pay extra for a plan that includes inventory tracking.

reddit.com
u/21stcenturycoolgirl — 24 days ago
▲ 4 r/QuickBooks+1 crossposts

Automating classes in QBO

I'm a bookkeeper for a woman who tracks her personal expenses separately from her joint expenses with her husband. Her personal bank account and two credit cards should always have Class = Personal, and her joint bank account and credit card should always have Class = Joint. I have rules set up for common transactions, but of course she's always going to new restaurants, doctors, stores, etc. so new vendors pop up all the time. Is there a way to automate the class tracking? Obviously I can manually choose a class when coding the transactions, but that introduces human error. You'd think the AI would have figured this out after a few years!

reddit.com
u/21stcenturycoolgirl — 1 month ago

Bookkeeping for an Insurance agent - advice and guidance needed!

I'm a bookkeeper and I have a new client who is an independent insurance broker. It's become messy and I am not sure if it's just the way this goes, or if the client is disorganized. If the latter, I'd love advice on systems and processes that I could suggest to make this easier.

She has two checking accounts: one for Operations and one as a Trustee account for client premium payments. There is a Funds Held in Trust liability account.

Some policies are Agency Billed. She invoices via QBO, which deposits into the Trustee checking. She pays the carrier out of the Trustee checking, less a commission that she transfers back to the Operations account.

Other policies are Direct Billed to the carrier. The carrier pays her commission into the Operations account, sometimes several policies in one deposit. Occasionally she invoices the client directly for the broker fee.

I spent *far* too many hours building out a spreadsheet tracking client invoice payments, commission transfers, payments to carriers, and carrier commission payments. Even just typing all this out is exhausting! I also had to track my manual JEs to recognize the commission revenue and reduce the Funds Held in Trust from the commission taken out of the premium payments.

It is still not totally clean, I sent the client a spreadsheet asking her to fill in the gaps. I asked how she tracks client policies and her response was to explain again how she makes commissions and fees...so I am wondering if she actually *has* a system? I feel like there must be a better way to do this, so I would really appreciate any guidance!

reddit.com
u/21stcenturycoolgirl — 2 months ago

Bookkeeping for insurance brokers - advice and guidance needed!

I'm a bookkeeper and I have a new client who is an independent insurance broker. It's become messy and I am not sure if it's just the way this goes, or if the client is disorganized. If the latter, I'd love advice on systems and processes that I could suggest to make this easier.

She has two checking accounts: one for Operations and one as a Trustee account for client premium payments. There is a Funds Held in Trust liability account.

Some policies are Agency Billed. She invoices via QBO, which deposits into the Trustee checking. She pays the carrier out of the Trustee checking, less a commission that she transfers back to the Operations account.

Other policies are Direct Billed to the carrier. The carrier pays her commission into the Operations account, sometimes several policies in one deposit. Occasionally she invoices the client directly for the broker fee.

I spent *far* too many hours building out a spreadsheet tracking client invoice payments, commission transfers, payments to carriers, and carrier commission payments. Even just typing all this out is exhausting! I also had to track my manual JEs to recognize the commission revenue and reduce the Funds Held in Trust from the commission taken out of the premium payments.

It is still not totally clean, I sent the client a spreadsheet asking her to fill in the gaps. I asked how she tracks client policies and her response was to explain again how she makes commissions and fees...so I am wondering if she actually *has* a system? I feel like there must be a better way to do this, so I would really appreciate any guidance!

reddit.com
u/21stcenturycoolgirl — 2 months ago

Bookkeeping for insurance brokers - advice and best practices

I'm a bookkeeper and I have a new client who is an independent insurance broker. It's become messy and I am not sure if it's just the way this goes, or if the client is disorganized. If the latter, I'd love advice on systems and processes that I could suggest to make this easier.

She has two checking accounts: one for Operations and one as a Trustee account for client premium payments. There is a Funds Held in Trust liability account.

Some policies are Agency Billed. She invoices via QBO, which deposits into the Trustee checking. She pays the carrier out of the Trustee checking, less a commission that she transfers back to the Operations account.

Other policies are Direct Billed to the carrier. The carrier pays her commission into the Operations account, sometimes several policies in one deposit. Occasionally she invoices the client directly for the broker fee.

I spent *far* too many hours building out a spreadsheet tracking client invoice payments, commission transfers, payments to carriers, and carrier commission payments. Even just typing all this out is exhausting! I also had to track my manual JEs to recognize the commission revenue and reduce the Funds Held in Trust from the commission taken out of the premium payments.

It is still not totally clean, I sent the client a spreadsheet asking her to fill in the gaps. I asked how she tracks client policies and her response was to explain again how she makes commissions and fees...so I am wondering if she actually *has* a system? I feel like there must be a better way to do this, so I would really appreciate any guidance!

reddit.com
u/21stcenturycoolgirl — 2 months ago

Prospective retail client: questions and advice

I'm a bookkeeper and I have been talking with the owner of a brand new used bookstore about setting up her books. I love the store and would love to support her as she grows her business. However, I don't have much experience with retail.

I have standard intake form I have prospects fill out before we meet, but I find that when I am wading into new industries, there are always questions that I wished I had asked earlier. I would love to hear your ideas of what to ask her, what to look out for, etc.

What I know:

- She uses Square POS and Square Payroll (which she runs). I have heard Square integration with QBO is tricky. Any advice there would be appreciated.

- She is tracking inventory and she has SKUs, I'm not sure with what app. Most of her books are donated or she buys for cheap, so COGS is low. What should I ask about inventory management? And do you recommend syncing inventory with QBO?

- She mentioned something about Profit First Accounting. I don't know if that actually affects how I will set up QuickBooks or do her reporting?

Edit: found out she will also be selling online on multiple sites

reddit.com
u/21stcenturycoolgirl — 2 months ago

Questions for prospective retail client

I'm a bookkeeper and I have been talking with the owner of a brand new used bookstore about setting up her books. I love the store and would love to support her as she grows her business. However, I don't have much experience with retail.

What I know:

- She uses Square POS and Square Payroll (which she runs). I have heard Square integration with QBO is sketchy. Any advice there would be appreciated.

- She is tracking inventory and she has SKUs, I'm not sure with what app. Most of her books are donated or she buys for cheap, so COGS is low.

- She mentioned something about Profit First Accounting. I don't know if that actually affects how I will set up QuickBooks or do her reporting?

I have standard intake form I have prospects fill out before we meet, but I find that when I am wading into new industries, there are always questions that I wished I had asked earlier. I would love to hear your ideas of what to ask her, what to look out for, etc. lol

Edit: found out she will also be selling online on multiple sites

reddit.com
u/21stcenturycoolgirl — 2 months ago
▲ 2 r/xero

Recode a line from a paid invoice

I'm a bookkeeper and my client uses Xero. They sent out an invoice that had two line items, one for the consulting services and one for expenses. The customer paid the invoice. However, their EA said not to bill separately for expenses, just include the amount in the services line*. How do I edit the invoice/payment to change the account to from Expenses to Services?

*Since their EA made the call, and I don't give tax advice, let's not debate whether this is the right thing to do. It's also a fraction of the total invoice.

reddit.com
u/21stcenturycoolgirl — 2 months ago
▲ 2 r/xero

Edit reconciled transaction while reconciling period

I'm a bookkeeper who is more familiar with QuickBooks than Xero, and need advice on process.

We've all been in the situation where you're reconciling the period and you realize that a transaction is mis-categorized. Is there a way to click into the transaction from there and edit it to change the account? The only way I've found to do it is to go back the account transactions tab and find the transaction there and edit it. Which works, but it takes you out of your workflow.

reddit.com
u/21stcenturycoolgirl — 2 months ago

Question about Gusto charge

I'm a bookkeeper and I have a new client who has a brand new company. They are using Gusto for payroll. I integrated it with QBO and synced the historical payrolls, no problem.

There is a $190 charge in their bank account on the first of the month for "Electronic Withdrawal Gusto". When I run a report in Gusto for bank transactions it says "Debit payroll fee". Is this the software charge for using Gusto? Something else? It has been a long time since I have had a Gusto client and it was never fresh like this, so I have nothing to compare to.

Edit: I don’t have access to their subscription settings and the owners are out of the country so I am trying to reduce the number of transactions I ask them about.

reddit.com
u/21stcenturycoolgirl — 2 months ago

Gusto charge question

I'm a bookkeeper and I have a new client who has a brand new company. They are using Gusto for payroll. I integrated it with QBO and synced the historical payrolls, no problem.

There is a $190 charge in their bank account on the first of the month for "Electronic Withdrawal Gusto". When I run a report in Gusto for bank transactions it says "Debit payroll fee". Is this the software charge for using Gusto? Something else? It has been a long time since I have had a Gusto client and it was never fresh like this, so I have nothing to compare to.

Edit: I don’t have access to their subscription settings and the owners are out of the country so I am trying to reduce the number of transactions I ask them about.

reddit.com
u/21stcenturycoolgirl — 2 months ago

Kaiser pharmacy bill?

I'm helping a relative who just switched to Kaiser with her finances (I do not have Kaiser). I have had no issue logging into the kp.org portal and paying bills. However she has a pharmacy bill associated with a hospital stay that perplexes me. It doesn't show up in either the billing or pharmacy portion of her portal. And the website that it says to pay the bill is ncal.kprxbillpay.com which seems weird to me. Is this normal?

reddit.com
u/21stcenturycoolgirl — 3 months ago
▲ 2 r/xero

Coding transaction fees for invoices

I am a bookkeeper and I have a new client using Xero. They are a small consulting firm. When they receive invoice payments via ACH, there is a transaction fee taken out. Xero allows me to reconcile the payment to the invoice, but it shows that a small portion of the invoice is not paid. How do I code that to Bank Fees?

reddit.com
u/21stcenturycoolgirl — 3 months ago

I just signed on a new bookkeeping client and she added me to her QBO. I got the "[Client] has invited you to use QuickBooks Accountant" email but when I click the link I get "400 Bad Request" error. How do I fix this?

reddit.com
u/21stcenturycoolgirl — 4 months ago

I'm a bookkeeper, I have some familiarity with ecommerce because I worked at an ecommerce/accounting integration software company about a decade ago, but I have never had an ecommerce client. Today I have a meeting with a prospective client who has a couple different businesses, including starting an online store. (I think this is going to be a small side hustle.) They don't have their website or QBO or anything set up yet. What are some questions I should ask them to better understand their business? And anything I should guide them towards/away from?

reddit.com
u/21stcenturycoolgirl — 4 months ago